01/01/1900 was also a Monday... kind of convenient, too, because the decimal equivelent for that date is "0".

Be a bit leary of queries that have an inequality in the WHERE clause especially when a self-join is also present as it may form a "triangular join" which is a...

You say you specifically want to use BCP... try BULK INSERT instead... lot's simpler than trying to get around the command shell thing.

Also, you can still use command shell as...

Hat's off to the "remaining partner"... well done, Mr. Jones!

Like I said, unless there is something to force the order of the Task Description (another column, usually), there is no guarantee that the descriptions will come out in the...

Hi Ryan,

What did you come up with for the largest prime number found and how many prime numbers?   I wanna make sure I'm doing it right...

DO NOT USE @@IDENTITY because it is not scope sensitive... use SCOPE_IDENTITY() instead.

Cool... forgot about the mod.  Thanks...

Heh... you're right... no underscore... I shouldn't type late at night

Don't get me wrong... I love BCP!  I love it's ability to log,...

I agree with some of the others... the tone of the article is a bit distracting and takes away from the good technical content. 

It would also be nice if...

Using joins, create an "UPSERT"...

UPDATE where there's a match... INSERT where there isn't.

Might also want to check performance and resource usage of both... statement 2 is a correlated subquery and they can be quite greedy depending on the tables involved.

Heh... and I wouldn't do any of it in DTS.

This is a different problem... can be more easily done with the GROUPING key word in a group by.  But not possible either way unless we know what is the PK...

BCP is more robust.

BULK_INSERT is the fastest but not by a lot.

Both are nasty fast but BULK_INSERT can be run through a query without a trip through xp_CmdShell.  xp_CmdShell requires...