Hi gjuarez

Okay if you need that full dataset you will have to obtain the details after you carry out the pivot. The problem here is the PIVOT will group your...

Hi gjuarez

I have a feeling there are more columns in VW_ILLDISC1 than the few you stated in your original post, if that is the case the select * in the...

Hello 🙂

If you dont need them in seperate columns maybe give this a try:

--Create temp test table

CREATE TABLE #VW_ILLDISC1

(

Id INT NOT NULL,

IncidentId INT NOT NULL,

IncidentDescription NVARCHAR(10)

)

GO

--Populate temp...