You're welcome.

Jeff Moden (10/21/2010)

---

Thanks for the input, Johan. Heh... from what I've seen, even...

Oliiii (10/22/2010)

---

I understand your point of view, i admit my view of what is a "senior" DBA is influenced by my work, where some mistake/inefficiencies are not allowed (something you...

Why are you using a subquery for the final column? Why not just move "where i.[record type] = 'overall'" into the Where clause of the main query?

I'm not sure how an Instead of Delete trigger would know to run (actually delete stuff) the first time and not run in subsequent calls, without potentially complex "mutex" implementations...

Jeff Moden (10/20/2010)

---

What do you mean, Gus? How has it been worse? Implementation, performance,...

A) No, what I described doesn't match what you're asking. If you ask me to restore a database from a backup file, I'll use the wizard for it. ...

You're welcome.

Can you build a .NET DLL that will do the hashing for you? If so, you can use that in a CLR trigger in SQL 2005/2008. That should...

preensheen (10/20/2010)

---

GSquared (10/20/2010)

---

How are you building the header? If I remember correctly, you're using a local variable to do that. Can't you just add the quotes in the...

I'd search around (Google/Bing/whatever) and see if you can find a regex that can do that for you. There probably are some. That'll be your best answer to...

I'm assuming the existence of an outer table that lists the site/product combinations that are being queried.

If that's not the case, then a simple cross join of valid site IDs...

How are you building the header? If I remember correctly, you're using a local variable to do that. Can't you just add the quotes in the code where...

Craig, I think you're overcomplicating it. The select I wrote could certainly be built into a view.

You can Join by using a Like statement. That's probably what your teacher is looking for.

On the other hand, the "step through" makes it sound like the assignment might...