Post reply

Alternative to Cursor

  • September 10, 2013 at 4:02 pm

    #279598

    I am looking for a way to call a stored procedure for each record of a select statement.

    I have read that Cursor is a bad idea to do so...

    Then How should I call the store procedure to display each record without passing any parameters.

  • September 10, 2013 at 4:09 pm

    #1649050

    It depends on what the cursor and the SP do. To give a good advice you should give more details on what you're trying to accomplish.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • September 11, 2013 at 5:12 am

    #1649209

    Please provide some more information.....

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

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

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