I believe that Books OnLine has this.

You may want to move this thread to the SSIS forum then.

magarity kerns (12/22/2008)

---

So my question to the crowd here is: how happy or miserable is SQL Server (we'll be using 2008 Express) to run small student sized data and log...

Lookup BULK INSERT in Books OnLine.

That depends on what kind of error it is and whther you use TRY..CATCH.. to trap it or not.

Frankly, I cannot see a single reason to use a Cursor for this. It would work much better and faster if you dropped it.

Well it would depend on a lot of stuff that you haven't told us yet, but probably something like this:

Create Table #temp(

BirthYear smallint

, BirthMonth smallint

, BirthDay smallint

, FirstName varchar(24)

, LI...

True, but after 30 years of telling customers "it doesn't mean anything unless you already...

WRT = "with respect to"

but if you google you should find, except I'm from New Zealand where ironically our zeds are esses...

Neat query Jeffery. 🙂

Oh, I know what it is Jonathan, but it's still flaky.

Threshold alarms built on performance metrics that are entirely situational, and even then need to be volume-scaled are...

Well it's shorter than CASE, but not much beyond that.

Any chance we can get a link or reference to this WRT Database Design?

Thanks,

Frankly I am not seeing any evidence that you have a performance problem. The peformance metric...

It's an addiction, man, a crutch. Just give it up...