"Greforian?"   Do you mean "Gregorian" ?  Do you have a link that explains why 732312 equals to 1/1/2006?  Might be able to pull a rabbit out of the hat if...

I'm thinking that a couple of things are missing on this post, but, you can write to the client machine if you use a UNC path AND the SQL Server...

And, xp_FileExists does not require SA privs... neither does xp_DirTree which is xp_FileExists on steroids!

Remi,

Because she is using SELECT t1.*,t2.*, every spawned row is totally unique... DISTINCT will not work in this case...

If you can delete everything in the table, why can't you add an IDENTITY column?  This isn't making any sense...

The topper is separate date/time columns... one of those not so...

What do you do with names like Juliet Anne Belle Smith Jones?

P.S.

I hope to live long enough to see what happens when the pants fall off of the SmallDateTime datatype on 2079-06-07 00:00:00.000

The rule for leap years is...

Any year evenly divisible by 4 unless it is evenly divisible by 100 in which case it must also be evenly divisible by 400 to...

Hoo boy... here we go... actually, Eric is absolutely right... there is a time when you would want to have foreign keys to another database.  Here's an example as to...

Most folks use ISNUMERIC not to detect a datatype... they erroneously use it to detect if a column has all numeric digits...

You bet, guys... thanks for the feedback.

Please see the following...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=243646&p=2

Don't fight it folks... ISNUMERIC should never be used as ISALLDIGITS or vice versa.

Here, here, Kevin!  Any process other than single record GUI support that uses RBAR (pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row") either has an incorrect database...

But, Scott does

Scott had posted the very same question on the WROX forum (totally different URL)... there, they got a little carried away...

Scott,

Just making sure you got the answer for this same problem that you posted on the Wrox forum.

This is more than ten times faster than what they posted there.  I...