I have my sql data with column headers as below :
And I want my output as
That means I need all the columns in source as like same. But WeekDate Column should go as separate columns using SQL Server.
How can I achieve this. Please help.
Hi, To be more clear I have modified the source and required Target as below : Please look into it. Thank you for your help in advance.
answered Sep 12, 2017 at 04:36 AM