use sql911;
go
select counter,emp_short,trans_date,debit,credit
from trans02
where counter is not null;
go