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!!!