>
>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"?
Al Williams
Anola MB, CANADA