>

>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"?