I've been looking at this and here's what I've found so far. The

tempdb.information_schema.columns table does not have any information about the ##pivot table. This is causing @delim to be...

Thanks for the quick reply. I'm using the stock Pubs database and the code posted above by Mahesh with no changes. If I copy the code above, paste it into...

Hi All,

I've found the code posted by Mahesh in 2 places on the web and neither of them work. I've copied and pasted the Create Procedure code into the Pubs...