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