Post reply

multiple records

  • January 16, 2006 at 9:07 am

    #67256

    hi,

      i have a problem. I have a select statement that returns multiple records and for each record it returns I need do perform some more operations on the record. Could anyone suggest a good way to approach this problem.

    Thanks in advance

    slr

  • January 17, 2006 at 6:04 am

    #615111

    Yup - use SSIS, you want to create an Integration Services project in BI development studio.

    There are other ways around this problem, and you might want to consider looking at what microsoft are thinking about charging for it.

    You could use a stored procedure....

  • January 17, 2006 at 6:55 am

    #615133

    Soumya,

    You can accomplish further operation Insert/Update/Delete

     on Select result using

    1. Cursor   or

    2. While loop using temporary table to hold your select output.

    Better you provide more details of other operation that you want

    to perform on your Select Result.

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • January 18, 2006 at 1:56 pm

    #615619

    Thanks sameer. I implemented it using cursor.

    slr

     

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

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