Home Forums SQL Server 2008 SQL Server 2008 - General delete rows RE: delete rows

  • May 23, 2011 at 10:20 am

    #1328569

    laddu4700 (5/22/2011)

    Resolved.

    parent table column referring itself. that is why my sp is getting error nesting level exceeded (limit 32).

    I have modified SP and it worked

    WHERE SO2.Name = @cTableName and so1.name <> so2.name

    Thanks Lutz.

    Nothing to be thankful for as long as you still use the sproc you have. I second Sean comments and strongly recommend to get rid of the sproc.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]