Paul,

Thank you very much. I appreciate everyone's assistance with this.

Much Appreciated Flo.

Thank you!

Thanks so much Flo!

This works great! Just for my own understanding on the cursor though, how would I set the Fetch_Status?

Kind Regards,

Tim

Hi Flo,

I'm attempting to update col2. It is currently null. The updated value should be assigned to +1 each time Col3 is less than the record before it,...

Thanks Steve and Nick,

Yes, I understand to retrieve the data I am ordering it by the Id_Column. My concern was that because the database retrieves the data in what...

Thanks Nick,

So would importing using SSIS into a table with an identity column work to ensure the original sequence? Thus a query like the following would match the source:

Select...

Thank you Lutz

Thanks Lutz,

Unfortunately there is no true key to the data, and there are millions of rows (Manually adding them isn't going to work). The rows are ordered in a...

Is there a way to ensure that a flat file is loaded into sql in the exact sequence of the source file?

I am having a similar concern with a flat...