Home Forums SQL Server 2008 SQL Server 2008 - General A cursor with the name 'CursorName' already exists. RE: A cursor with the name 'CursorName' already exists.

  • May 25, 2012 at 2:44 am

    #1493001

    Thanks for this, I wasn't aware that CURSORs could be specified in context.

    If you had posed this as a problem I would have said to deallocate and close the cursor in the code immediately preceding your cursor definition.

    I'll read up on the syntax today if I get time. Cheers.

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.