I'm sure I'll get a bunch of hooey from the CLR zealots on this but, with the possible exception of some decent RegEx CLR's written by Matt Miller, I've not...

so I'm not completely sold on the PIVOT operator yet. I think it looks kind of clunky. Then again, we usually say that when we come across something new. Perhaps...

Heh... only if Set A has an alias of Set B 😛

More info...

You CAN do a dupe check using an after trigger... Again, ITS THE WRONG THING TO DO!!!! But it will help you "pass" if your instructor insists...

The problem with such a trigger is that you've created an "After" trigger... these types of triggers fire "After" the data has already been inserted. In other words, the...

Agreed... Bit values are, in fact, "tri-state"... off, on, and "don't know" and, depending on your requirements, that may or may not be important. For example, in a "testing"...

TBIG,

What you're describing is an "Audit Process" or "Audit Trail"... there are many ways to do this including Audit Triggers that save "old data" to an Audit table when data...

You're currently looking at one of the best resources there is for learning... SQLServerCentral.com. Everyday, I look at as many posts as I can... Some folks have some really...

That's probably because when you execute it from VB, you're doing it as embedded SQL... which has no chance of reusing an Execution Plan.

No...

But you can write forumulas in the Excel spreadsheet that will create the necessary INSERT/SELECT or INSERT/VALUES statements.

There's also several ways to import the data from a spreadsheet into SQL...

What are you running the code from? Query Analyzer or ???

The code, as I've posted it, runs fine...

Is it possible that you've run into the same problem a lot...

Just lucky... I happened to be "in the neigborhood" and just happened to have an answer...

Jeremy,

Do you have an example of how you'd solve the above using the Pivot operator?

You bet, Cali... thanks for the feedback.

I wish I could take the credit for the following bit of SQL prestidigitation, but I can't... thank "Sergiy" 😉

CREATE FUNCTION dbo.fnAddWeekdays (@Start DATETIME, @Days INT)

RETURNS DATETIME

...