I just don't see a need for the pricing table... all of the required information is in the parts table. There is no need to have duplicate information in...

Wow! Someone finally wrote a national article on exactly how I feel about certifications, degrees, and "boomers". Great "catch of the day", Steve!

Or, maybe get a little Edgar Rice Burroughs into it... "Ugh... Me DBA... you user!" 😛

Wayne West (7/21/2008)

---

Jeff Moden (7/21/2008)

---

[font="Arial Black"]Jeff Moden's Three Rules of DBA's.[/font]

1. A DBA may not injure data or performance of the data or, through inaction, allow data or performance of...

Heh... yeah... I'm the same way... it's easier for me to remember an aggregate qualified by a CASE than it is to remember the Pivot syntax because it's so simple....

jpowers (7/18/2008)

---

As with any technique for dealing with opponents (whether in communication or karate), one needs to use good judgment. No technique is good for all situations, and may...

No need to gloat... No sense in someone else solving it... you already did it! 😉

Yes, you can... you'll loose performance, as well. 😉 It turns out that Cross Tabs are generally quicker than Pivots especially if you preaggregate the data in a...

Heh... like everything else, it depends... it...

That's a bummer... just goes to show what I've said in the past when people pitch a fit about using undocumented stored procedures... I tell them "Look! Even the...

Instead of trying to reinvent the wheel... why not just use sp_MakeWebTask?

So, use something better like Bulk Insert.

What are you trying to do with the CLR?

Ya beat me to it, Chris. 🙂

Heh... trust me... with a little help from ROW_NUMBER(), aggregates are the way to go for this...

--===== Create...