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

CSDunn,

You can either use the forumla in the following in a UDF or directly...

SELECT DATEADD(yy,[Last Sale Date]/1000-1900,[Last Sale Date]-([Last Sale Date]/1000*1000)-1) AS [Last Sale Date]
  FROM dbo.tblPaymHistCurrentWeek

-1900 Serqiy

A view that looks like the following would certainly do it (untested)...

 SELECT d.FirstName   = MIN(CASE WHEN d.PropertyName = 'FirstName'   THEN d.PropertyValue ELSE '' END),

        d.LastName    = MIN(CASE WHEN d.PropertyName...

Wayne,

Whether I agree with the premise of using WITH (NOLOCK) or not, your post did what all good posts are supposed to do... spark pro/con conversation.

Thought I'd reward you...