Hi I have a table with this data structure (Before section)I have the query below to generate date as in (After section)But I would like to have (Desired section) view where start and end tasks are next to each other Any help will be greatHere is the query -----------------------------SELECT ID ,[Final] AS [Final Start] ,[Edit] as [Edit Start] ,[Proof] as [Proof Start] ,[Stage] as [Stage Start] ,[Marketing] as [Marketing Start] ,[Developer] as [Developer Start] ,[Promotion] as [Promotion Start] FROM (SELECT ID,TaskName,convert(varchar,[TaskStartDate],103) AS [TaskStartDate] FROM #TempTask) a PIVOT (max(TaskStartDate) FOR TaskName IN ( [Final] ,[Edit] ,[Proof] ,[Stage] ,[Marketing] ,[Developer] ,[Promotion] )) AS pvt