>>
>>strSQL = "exec dbo.sp_VarianceReport @UserName = wgriffiths, @SortOrder = CostCenter"
>>
>>
>>Try delimiting the parameters:
>>
>>
>>strSQL = "exec dbo.sp_VarianceReport @UserName = 'wgriffiths', @SortOrder = 'CostCenter'"
>>
>>
>>And, as Sergey mentioned, make sure that you have a SET NOCOUNT ON at the top of your stored procedure.
>>
>>-Mike
>
>
>Where to I issue SET NOCOUNT ON? Right after "Create procedure blahblah AS"?
Ignore the previous post - I didn't read Sergey's response closely enough - SET NOCOUNT ON did the trick. Thanks.
Al Williams
Anola MB, CANADA