Hi all.
I need to create a dynamic pivot table in my SQL but I will not be calculating in the table, I will just be "stringing out" values in two columns. I have tried many different examples of dynamic pivots but nothing seems to work.
There are multiple accounts and an indefinite number of 'PRV_DEP' records.
And it has to end up in a temp table so I can add it to the end of records in another table.
Any help would be greatly appreciated!
Thanks
Steve
