Post reply

Cursor is Refreshing Data After Open

  • October 7, 2005 at 12:25 am

    #89665

    I have Written Cursor like

    DECLARE Cur_Data CURSOR FOR

    SELECT Column1, Column2 FROM Table1 WHERE Column3 = 1

    OPEN Cur_Data

    FETCH NEXT FROM Cur_Data

    WHILE @@FETCH_STATUS = 0

    BEGIN

    INSERT INTO TABLE1 (Column1,Column2,Column3)

    VALUES (Value1,Value2,1)

    FETCH NEXT FROM Cur_Data

    END

    This Loop is running indefinitely

    Afterward we come to know it is because it is always refreshing it & take data from table where condition matchs

    What can i do if i want to add same data using Cursor ??

    Thanks in Advance

  • October 7, 2005 at 1:23 am

    #595779

    Maybe you've over simplified the code you've posted, but I'd just replace all that with,

    INSERT INTO TABLE1 (Column1,Column2,Column3)
SELECT Column1, Column2 FROM Table1 WHERE Column3 = 1

     

    --------------------
    Colt 45 - the original point and click interface

  • October 7, 2005 at 5:38 am

    #595814

    If you need to use cursor, then go for static cursor, that will not open the table anyway. It uses tempdb for its process.

  • October 7, 2005 at 5:48 am

    #595816

    If phill's right in his assumption of "oversimplification of code" then you should use his SQL - else Manish - it may be in your best interests to post what you actually want to do and someone is bound to come up with a better/faster/(& possibly) a cursorless way...







    **ASCII stupid question, get a stupid ANSI !!!**

  • October 7, 2005 at 8:57 am

    #595894

    "Cursorless"?  To cursor, or not to cursor.  That IS the question? 

     

    I wasn't born stupid - I had to study.

Viewing 5 posts - 1 through 4 (of 4 total)

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