I wanted to have a query in which i have to have an alias name in the case condition as follows :
select r.column1 as Name1,t.Column2 as Name2,
case @Month when 2 then t.Column1 as Jan when 3 then t.Column3 as Feb ... end
from table1 t ,table2 r
But it is giving syntax error for the same
.can anyone help me out on this case
|