Cast

[mayu03]

I have the following query where I am trying to create an extra line with a headers. But I am getting an error msg., because count in header is varchar , but in my select statement is int. How do I fix this problem?

Select 'Report' as 'Report' , 'Count'
Union
Select 'Report',count(*)
from table1

 

[swampBoogie]

Select 'Report'  as Report , 'Count', 1
Union
Select 'Report',cast(count(*) as varchar(20)),2
from table1
order by 3

 

[nikhilparchure]

Select 'Report' as 'Report' , 'Count'
Union
Select 'Report',convert( varchar(20) ,count(*))
from T_REFDATA
Order By 2 Desc

similar to the first post..but didnt use extra column

Parchure Nikhil