vax750,

If you are going to use CASE, Michael's solution is more efficient:

DECLARE @Sample

TABLE (

account INTEGER NOT NULL,

...

Isn't Bob's/Dixie's article an excellent read today?

Shame about some of the layout, but hopefully that will be fixed soon.

Most enjoyable.

The Dixie Flatline (3/16/2010)

---

Paul: I will read over the article and see if Steve can make the changes. It's also been pointed out to me that a script...

The XML PATH solution is a good solution, I just want to add a couple of things, and neaten things up a bit:

DECLARE @Jobs

TABLE (

...

The usual solution is to use one of the bulk import methods, in minimally-logged mode.

The section of Books Online that deals with this is Importing and Exporting Bulk Data.

sp_change_users_login is on the deprecation list - it will be removed from a future version of SQL Server.

You should use ALTER USER...WITH LOGIN instead.

There is another way, less common than that suggested by Lowell, which suits some circumstances.

It has the advantage of being able to use any useful index that might exist.

Sample data:

DECLARE...

Just out of interest...why the old samples, and why the deprecated osql utility?...

See if you can include that http://en.wikipedia.org/wiki/Argument_from_authority link. Very cool.

Other thing that frustrates me, along the same lines, is people insisting that a...

Sure thing. If I remember, I will send you a PM too.

Excellent stuff Bob. The first article on SSC I have really enjoyed reading for quite some time. Well done!

It is a shame about some of the code formatting...

GilaMonster (3/16/2010)

---

Paul White (3/15/2010)

---

GilaMonster (3/15/2010)

---

I hate to ruin the good mood, but could anyone keen on bashing their head against a wall for a coupl hours follow up on this....

mister.magoo,

There really was no need for that, for my part, but thanks for your kind words anyway 🙂

You do raise an interesting point regarding the potential for incorrect results if...

Why post the same thing three times?

If Jeff chooses to assist you again, it will be at his convenience.

No, that is not the case. Your statement...