sql server - how to convert rows to columns using sql query -
pls see below query select d.emp_id, e.emp_name, a.proj_code, b.proj_name, a.activity_code, c.activity_name, convert(char(4), a.effort_date, 100) + convert(char(4), a.effort_date, 120) month, a.effort_hours timesheet_activity left join project_master b on a.proj_code = b.proj_code left join activity_master c on a.activity_code = c.activity_code left join timesheet d on a.timesheet_id = d.timesheet_id left join employee_master e on d.emp_id = e.emp_id b.proj_name in ('sales support') , (a.effort_date between (select convert(varchar(10), convert(date, '30-06-2014', 105), 23)) , (select convert(varchar(10), convert(date, '02-07-2014', 105), 23))) the result this. now want show below. emp_id emp_name proj_code activity_code activity_name jun 2014 jul 2014 101257 chris 1001 9001 test 1.5 1 i want make months columns , show efforts hours same. any suggestions highly appreciated with abc ( pas...