Data is not displaying in 1 rows

Question

Hi I have below View but it is not displaying Level data in 1 row. Image attached

Ramco Ramco · Answer

Hi Amit Below is the query . I want to display data in 1 row .In below code there are 12 levels , i want data in 1 rows. I am following this link - https://www.datameer.com/blog/sql_how-to-use-pivot-to-convert-rows-to-columns-in-sql-server-db/ Hi Amit If i comment below lines then it is working fine , but i want to add these columns also. --,L.[LogDetail] [Status] --,L.[RequestDate] [Entry Date] --,L.[ApprovalDate] [Completion Date] --,DATEDIFF(d,L.[RequestDate],L.[ApprovalDate]) as [Total Days] PR Number Status Entry Date Completion Date Total Days DaysToApprove LevelName 209 PR Request Approved 2020-04-07 12:57:32.833 2020-05-07 12:44:43.307 30 30 Level 1 209 PR Request Approved 2020-05-07 12:44:43.307 2020-05-08 16:21:39.327 1 1 Level 2 209 PR Request Approved 2020-05-08 16:21:39.327 2020-05-18 17:53:29.793 10 10 Level 3 209 PR Request Approved 2020-05-18 17:53:29.793 2020-06-26 10:56:05.847 39 39 Level 4 209 PR Request Approved 2020-06-26 10:56:05.847 2020-07-07 09:05:04.503 11 11 Level 5 209 PR Request Approved 2020-07-07 09:05:04.503 2020-07-07 09:05:36.577 0 0 Level 6 209 PR Request Approved 2020-07-07 09:05:36.577 2020-07-07 12:18:20.127 0 0 Level 7 209 PR Request Approved 2020-07-07 12:18:20.127 2020-07-08 16:24:42.723 1 1 Level 8 209 PR Request Approved 2020-07-08 16:24:42.723 2020-07-08 16:26:17.620 0 0 Level 9 209 PR Request Approved 2020-07-08 16:26:17.620 2020-07-10 09:31:18.310 2 2 Level 10 209 SAP PR Number Updated 2020-07-10 09:31:18.310 2020-07-10 10:56:16.060 0 0 Level 11 209 PR Request Approved 2020-07-10 10:56:16.060 2020-07-16 12:03:01.053 6 6 Level 12 Thanks

Amit Mohanty · Answer

Can uoy please explain your issue more properly?

Data is not displaying in 1 rows

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)