Obviously Steve Jones is dealing some people doing ridiculous grade-school stuff, so I applaud his attempt to clarify issues. And he does a pretty good job. But unfortunately...

Rachel,

Yeah, a staging table of some sort is ideal for this.

I'm assuming you want all changes in the same transaction, so that if one change fails due to...

Pretty well written article, but I'm confused. I thought "Arrays" where called "Tables" in SQL Server.

Why do people keep saying SQL server doesn't support arrays? Maybe...

Quote dcpeterson: I guess proof is what you need...

That was not an accurate test; you'd need to destroy and re-create the table for each test in order for it to...

While 1 = 1

BEGIN

Select top 1

@var...

I like the formatting hints in your article. I would have saved some trial and error time if I'd read this a few years ago.

Personally, I've used dynamic SQL...

Thanks for the tip, JT; I'll have to check it out.

Honestly, I'm annoyed I have to organize my movies at all. I mean; come on...here's how I would like...

Poker; I love poker, mainly texas hold-em ring games. Been playing for about 6 years. It's been super popular lately, which is fun (lots of fish!). New...

98 was not a stable operating system; and the large number of crappy applications written for it sure didn't help. NT pre-4.40 was not very stable either, at least...

"net also posted an article on dual core amd vs. Intel, where intel did not win a single benchmark test!"

Ummm...this doesn't mean they're biased, right? Could it be, gasp!,...

Wow...seems like suddenly everyone is talking about this potential problem. I read an article about this earlier this week, and the symptoms described an ETL process we've been having...

This is a fundamentally important question...whose PC is it, anyway? Is it the person's who manufactured it, or wrote the drivers? Is it the person's who wrote the...

That is extremely weird! And I don't think anyone was insulting your intelligence; you'd be suprised at what kind of questions get asked, and how are we to know...

This may help...for BOL:

SET TEXTSIZE 0

-- Create variables for the character string and for the current

-- position in the string.

DECLARE @position int, @string char(8)

-- Initialize the current position and...

You are using a temporary table, dynamic SQL, and a cursor. These are all three big no-nos, unless you have an extremely valid reason. I'm guess you could...