No, I can not replace the 2nd proc's code into the first one, for the second one is a stand alone. In fact, there is a whole slew of procs...

Thanks, Jeff. I tried using xp_DirTree but it only gets me the file names. I need to sift through the files based on the file types and their create/modified times...

Thank you guys! I appreciate that.

SC

No replies? 🙁

I would appreciate any kind of help on this!

These are mostly for one-time deployment. I wouldn't be reusing them at all.

It will be great if you can provide me some :). I am also looking for a framework which can be generally used to logging the execution results (time taken,...

Thanks for all your inputs and suggestions. I will work towards implementing this in SSIS which seems to have better control. I appreciate everyone's time and effort in providing valuable...

Fantastic! Thanks for being so patient, Scott. It's appreciated very much!

- Rex

I think your query is still missing the new column, "ItemSortOrder". Sorry, if I am starting to get to your nerves...my apologies! 🙁

Please see the image below that shows what...

Scott,

I think we have a slight disconnect here :). Your query is selecting from @ItemListOutput, which is where I included "ItemSortOrder" column. I did this to show my desired result....

Scott,

Thanks for your suggestion, but your query won't give me the sort order id for each individual item of an order. Please look at the last column of @ItemListOutput table...

@Milos.radivojevic - Your solutions works perfectly to take care of my requirement. Thank you very much.

- Rex

Please check the SQL snippet below and also the attached image for before and after snapshots of the data. I hope it helps.

-- Table1 has just MyID...rest of the columns...

Lowell/Sean/Jeff,

Thanks for your valuable inputs. The table I mentioned above is just a fake one to simulate my requirement. My actual table columns range anywhere between 20 to 80, with...

Thanks, Scott & Dwain.