:crying:Soz - still getting 2 errors depending on the param's:-

Running [dbo].[U_SorTransaction_SelectAllBackOrders] ( @SalesOrderID = 557152, @AllocationEndDate = 11/14/2008 ).

Syntax error converting the varchar value ' Where

...

After putting in your last mod, I get 2 different results:-

Pass Zero & 11/14/2008:-

Running [dbo].[U_SorTransaction_SelectAllBackOrders] ( @SalesOrderID = 0, @AllocationEndDate = 11/14/2008 ).

Must declare the variable '@AllocationEndDate'.

No rows affected.

(0 row(s)...

HI,

I understand what you meant now! dur

But I dont under stand the output when I try & execute it....

Running [dbo].[U_SorTransaction_SelectAllBackOrders] ( @SalesOrderID = 557152, @AllocationEndDate = 11/14/2008 ).

Procedure expects parameter...

I am calling the stored procedure directly from C# (which is my area of expertise). This will be called from many places within code - so ideally I would like...