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...

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...

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...

PhilPacha (12/29/2008)

---

Hmmm... Simple addition will NOT work. Multiplication is also needed.

Example 1: 2009 + 1 + 2 = 2012 (January 2, 2009)

Example 2: 2009...

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,...

RBarryYoung (12/29/2008)

---

Matt Miller (12/29/2008)

---

Sorry to say - it's coming.... ^%%$#@$^%&* semicolons will eventually be required on all SQL statements. You can thank the ANSI board for that one. ...

Matt Miller (12/29/2008)

---

Matt Miller (12/29/2008)

---

Jeff Moden (12/26/2008)

---

Just bought a nice new Calypso Cruiser (bicycle)......

RBarryYoung (12/29/2008)

---

For what it's worth, I think that one exercise that we should all try is to seriously consider what good the forum Taxonomy/Structure truly does for each of us...

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...

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...

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

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...

Or, you can do something similar to what's in the following link...

http://www.mssqltips.com/tip.asp?tip=1643

feodon (12/29/2008)

---

Hello Jeff Moden , thanks for your precise look at my code

What if we have a more complicated text ,

It worked with simple texts ,

but when I copied fore...

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...