Viewing 15 posts - 46,291 through 46,305 (of 59,062 total)
Without more information, I'd have to say "like you would anywhere else". Insert from one table to the other using Insert/Select... then, delete the rows you just moved from...
December 29, 2008 at 6:34 pm
Dunno if this will work on 64 bit... but I think you'll like it if it does...
/**********************************************************************************************************************
Purpose:
Returns a single result set similar to sp_Space used for all user...
December 29, 2008 at 6:26 pm
If the file is a "continuous" log instead of a file to be created on the fly, look into the simplicity of making a Text based linked server... a pretty...
December 29, 2008 at 6:13 pm
PhilPacha (12/29/2008)
Example 1: 2009 + 1 + 2 = 2012 (January 2, 2009)
Example 2: 2009...
December 29, 2008 at 6:06 pm
Heh... I guess I don't use WHERE EXISTS for the same reason I don't use Try/Catch... I know the database and I know the DRI... when I join on something,...
December 29, 2008 at 6:00 pm
RBarryYoung (12/29/2008)
Matt Miller (12/29/2008)
December 29, 2008 at 5:56 pm
Matt Miller (12/29/2008)
Matt Miller (12/29/2008)
Jeff Moden (12/26/2008)
Steve Jones - Editor (12/26/2008)
Congrats!Hey, pick up running as a new vice, that's what I did 🙂
Just bought a nice new Calypso Cruiser (bicycle)......
December 29, 2008 at 5:52 pm
RBarryYoung (12/29/2008)
December 29, 2008 at 5:43 pm
Dang... sorry Grant... wasn't directed at you. It was directed at folks that somehow think it's OK in any way, shape, or form, to have unecrypted SSN's and the...
December 29, 2008 at 6:36 am
Just so you know... storing dates in a database like that is a form of "Death by SQL"... it will bite you sometime in the future.
The only reason you should...
December 29, 2008 at 5:39 am
For the record, here's how I'd do it... very very fast because there's only 1 conversion and the rest is all integer math...
SELECT ABS(CHECKSUM(NEWID()))%900000 + 100000
December 29, 2008 at 5:31 am
I wouldn't use RAND() to generate the random number because if more than one row is returned in a given Select that uses it, ALL of the supposedly random numbers...
December 29, 2008 at 5:28 am
Or, you can do something similar to what's in the following link...
December 29, 2008 at 5:16 am
feodon (12/29/2008)
What if we have a more complicated text ,
It worked with simple texts ,
but when I copied fore...
December 29, 2008 at 5:10 am
Ok... there's a couple of problems with that... first, you're updating 3 of the 4 indexes on the table. Like I said, that's gonna slow things down quite a...
December 29, 2008 at 5:05 am
Viewing 15 posts - 46,291 through 46,305 (of 59,062 total)