How to count number of rows

Hello, Dean
Try this:

select distinct c1, c2 into #tmp_1 from t1
select count(*) as cnt from #tmp_1
drop table #tmp_1

With best regards.how to count number of rows?

well, try this...

select count(*)
from <yourtable>