[dba-SQLServer]Exporting SPROC with Parameters to Excel

Thu Apr 3 21:22:23 CST 2003

Solved!

The problem seemed to be with specifically listing the parameters -

This didn't work -
     strSprocName = "EXEC spBookingExport @txtMDQSeasonAdj='0', 
@txtMDQDivider='20'"

This did -
     strSprocName = "EXEC spBookingExport '0', '20'"

Regards

David Emerson
DALYN Software Ltd
25b Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (877) 456-1205  