Hi Lynn,

Thanks for the response.

I didn't save the proc script. I just tried a few permutations but the error message was something like incorrect syntax near "set"

I will...

Hi again.

here is the original script before any adjustments.

-- Dynamic PIVOT

IF OBJECT_ID('#External_Referrals') IS NULL

DROP TABLE #External_Referrals;

GO

DECLARE @T AS TABLE(y INT NOT NULL PRIMARY KEY);

DECLARE

@cols AS NVARCHAR(MAX),

@y AS...