Post reply

Params in sprocs

  • October 31, 2008 at 9:30 am

    #214799

    exec sp_DeleteDatafromAudit

    @ProcMonth = 9

    @Company = FUL

    @Extract_type =A

    Anyone know why the syntax for this statement is failing? Something about encapsulating the parameters??

  • October 31, 2008 at 9:32 am

    #892416

    You will need to put commas (,) between your Params..

    exec sp_DeleteDatafromAudit

    @ProcMonth = 9 ,

    @Company = 'FUL',

    @Extract_type ='A'

  • October 31, 2008 at 9:48 am

    #892429

    That worked grand, thanks for the quick reply!!!

    🙂

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply