As for the untested code sample. Here is a tested (and debugged) version for anyone interested;

DECLARE @tablename nvarchar(50)

DECLARE @groupby nvarchar(50)

DECLARE @pivcol nvarchar(50)

DECLARE @datacol nvarchar(50)...

I had a serious problem with the Enterprise Manager which was fixed by the installation of MDAC 2.8.

Whenever I tried to open a database, the server connection was lost. Unfortunately I...