I have a query in which I want some columns to be appear as Rows.
The query is
Select * from Emp_mon_day where emp_mkey IN
(select emp_card_no from emp_mst where comp_mkey in
(7,110)) and Year = 2016 and month = 2
and Emp_mkey = 2492
whose out put comes as
Now, I want to show Day1, Day2, Day3 as Rows in the output with the above query. How to achieve that ?
I am using SQL server 2008