Home Forums SQL Server 2008 SQL Server Newbies I have written a Stored Procedure having 3 nested while loops in it .This is Working fine and I am getting desired result as I have tested this on small set of data ,but while running on large set of records it taking huge of amount of time, might be due to multiple nested while looping . Co RE: I have written a Stored Procedure having 3 nested while loops in it .This is Working fine and I am getting desired result as I have tested this on small set of data ,but while running on large set of records it taking huge of amount of time, might be due to multiple nested while looping

  • September 11, 2013 at 6:00 am

    #1649230

    mishra.vipinkumar001 (9/11/2013)

    Hi Guys,

    Any Update on this .

    Have you looked to see whether the code ChrisM posted would help you get somewhere on this?

    Tom