Skip to Content
Former Member
Sep 09, 2010 at 03:11 PM

how to pass a variable to SP from querry generator in SAP b1


hi experts,

i am able execute the following query ,

exec sp_Attendance_Report '09','2010'

actually i need to pass month and year as variable to SP ,how to do that

i tried with the following

exec sp_Attendance_Report '[%0]','[%1]'

i m getting the following error message

1). [Microsoft][SQL Native Client][SQL Server]Must specify table to select from.
2). [Microsoft][SQL Native Client][SQL Server]Statement 'Service Contracts' (OCTR) (s) could not be prepared.

please help me to solve this issue

thanks in advance