Heh... if YOU had a question on what it does, others will to. Time to break out the grossly underused "dash dash" function. 😉

Like Carl said... can't be done by a computed column... but, you could use a view for this. Carl also suggested that you could use a trigger and that...

Once the text server (linked server) has been established, you don't need to make a trip to the CmdShell to get a listing of files in the directory....

...

Ok... sorry for the delay.

Here's the test data I used... Just to keep things consistent, I made sure there were no duplicates on the GebID/Load_Dts combination of columns...

--===== Create and...

Heck... that true even about stuff...

By the way... just to explain my embarrassing statements... here's why I said them. All I did was change the table name from #t to t and name the...

Michael Valentine Jones (9/6/2008)

---

I have posted examples like this on SQLTeam several times that shows a select from a table with a clustered index that returns results not in cluster...

Hey guys... I put some bum dope out about the clustered index method and I've edited out the post I made about it. My fault, I didn't test well...

timothyawiseman (9/5/2008)

---

Jeff, I must be missing something. Why would you want to do the sort in the gui instead of letting the server do that?

I do understand why...

Sorry... I put some bum dope out :blush: and deleted this entry.

Sorry... I overlooked the part about the "client's hosted app"... does that mean it's a 3rd party app that the client cannot change?

Hiearchy can be a good thing... but I don't believe the op can change the structure of the tables. 😉

CS... Please pardon me if I'm wrong, but this looks...

Phil Factor (9/25/2007)

---

Er.. The temporary table had an identity column in there that was intended to ensure precisely...

spiegdon (10/15/2007)

---

Thanks very much for the quick response, I am sorry for the long delay in ack.

We ended up going with the cursor approach as all we are...

Thanks, Pam... I appreciate your feedback. And, cool Avatar! Welcome to SQLServerCentral.com! 🙂