August 4, 2021 at 4:58 pm
I have the following query
SELECT DISTINCT E.[Widget_ID],l.[Widget_Name]
FROM LandingTable l
LEFT JOIN PROD_Table E ON l.[Widget_Name] = E.[Widget_Name]
WHERE E.[Widget_ID] IS NULL
My results are
Widget_ID Widget_Name
NULL Widget_1
NULL Widget_2
How can I pivot the Widget_Name column so my new result set is as follows
Widget_Names
Widget_1, Widget_2
August 5, 2021 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
August 5, 2021 at 9:56 pm
For 2016 and below - you can use FOR XML, for 2017 and above you can use STRING_AGG.
Declare @testData Table (Widget_ID int, Widget_Name varchar(10));
Insert Into @testData (Widget_ID, Widget_Name)
Values (Null, 'Widget_1')
, (Null, 'Widget_2');
Select *
, Widget_Names = stuff((Select concat(',', td2.Widget_Name)
From @testData td2
Where td2.Widget_ID Is Null
Order By
td2.Widget_ID
For xml Path(''), Type).value('.', 'varchar(8000)'), 1, 1, '')
From @testData
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply