Viewing 15 posts - 48,391 through 48,405 (of 59,064 total)
Heh... if YOU had a question on what it does, others will to. Time to break out the grossly underused "dash dash" function. 😉
September 6, 2008 at 6:08 pm
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...
September 6, 2008 at 6:04 pm
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....
...
September 6, 2008 at 6:01 pm
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...
September 6, 2008 at 5:05 pm
Michael Valentine Jones (9/6/2008)
There is nothing preventing them from making a change in the next version or even service pack that changes how it works.
Heck... that true even about stuff...
September 6, 2008 at 2:32 pm
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...
September 6, 2008 at 10:20 am
Michael Valentine Jones (9/6/2008)
September 6, 2008 at 10:10 am
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...
September 6, 2008 at 9:58 am
timothyawiseman (9/5/2008)
I do understand why...
September 6, 2008 at 9:29 am
Sorry... I put some bum dope out :blush: and deleted this entry.
September 6, 2008 at 8:11 am
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?
September 5, 2008 at 8:46 pm
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...
September 5, 2008 at 8:25 pm
Phil Factor (9/25/2007)
Jeff Moden (9/25/2007)
Phil's method only works if the ID is contiguous and sequential.
Er.. The temporary table had an identity column in there that was intended to ensure precisely...
September 5, 2008 at 7:17 pm
spiegdon (10/15/2007)
We ended up going with the cursor approach as all we are...
September 5, 2008 at 7:09 pm
Thanks, Pam... I appreciate your feedback. And, cool Avatar! Welcome to SQLServerCentral.com! 🙂
September 5, 2008 at 6:54 pm
Viewing 15 posts - 48,391 through 48,405 (of 59,064 total)