Skip to Content
0
Former Member
May 10, 2010 at 07:39 AM

Stored Procedure

40 Views

Hi,

I have created one stored procedure in sql for getting some complex report, its working finely in SQL, i have 3 parameters for this procedure.

They are @begindate, @enddate, @openingbalance.

Now i wants to use this Stored Procedure in SAP B1.

For that i have created the following query in Query generator in B1

Declare @d1 as datetime, @d2 as datetime, @ob as numeric(5,2)

Select @d1= [%0]

Select @d2 = [%1]

Select @ob = [%2]

Exec dbo.[RG1_Report] @d1,@d2,@ob

But this code is giving error...

Can anyone pls suggest me for this scenario.

Thanks in Advance!!!