declare @p5 int
set @p5=0
exec sp_executesql N'EXEC @RETURN_VALUE = [dbo].[SalesByCategory] @CategoryName = @p0, @OrdYear = @p1',N'@p0 nvarchar(9),@p1 nvarchar(4),@RETURN_VALUE int output',@p0=N'Beverages',@p1=N'1997',@RETURN_VALUE=@p5 output
select @p5