Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Thanks to Rob Volk and his TRANSFORM solution

Author  Topic 

Arnon
Starting Member

1 Post

Posted - 2002-06-18 : 06:59:22
We have transfered from MS Access to SQL Server.
I had a problem using Rob's solution to the Access TRANSFORM option.
We created the CrossTab Stored procedure. It was runnin using T-SQL but failed once we run it in VBScript using ADO.

Rob suggested that the problem may be in the ADO Connection permissions - and HE WAS RIGHT !!

Thanks Rob. I hope this info will help others.

Arnon

mdelgado
Posting Yak Master

141 Posts

Posted - 2002-06-20 : 17:09:43
I too transferred over from Access to SQL and Robs Crosstab solution helped me out a great deal.

Thanks again Rob!!

Go to Top of Page
   

- Advertisement -