select newid() as 'New id',
       rand() as 'Random not working',
       checksum(newid()) as 'Checksum',
       counter,emp_short,trans_date,debit,credit
from trans02
where counter is not null
order by 3;