Randy Petty (2/8/2008)

---

Fairly soon those of us supporting the legacy product will need to learn to work with the new database, which is very highly normalized. Instead of...

I'm also thinking you might get slightly better performance with a CTE:

;with DartCTE as

(

...

You'd want to think up an appropriate way to combine the two into a single value and ORDER by that.

In other words, in the case you mentioned where the count...

They also serve different purposes. Put simply - the Primary Key is the "external address", the clustered key is the "internal address". Meaning - the Clustered key tells...

Not that this is much consolation - if you set the "IF NOT EXISTS" scripting option to true, it will include the CREATE syntax, but it will get bypassed on...

You're in SSIS! (sorry - missed what forum you posted to) That does change things a little. Frank is right - you probably should use the unpivot component....

ChrisMoix (2/8/2008)

---

I thought that the Vostro line was for small businesses - i.e. they require buying in lots of five or more.

I know someone who tried to call and...

Not to take anything away from Antonio's solution - that's an ITERATIVE process, not a recursive one.

I've seen someone post a RECURSIVE version (using a CTE to get there), but...

Matt Miller (2/5/2008)

---

Jeff Moden (2/5/2008)

---

It IS a cool solution... Wasn't so good in the performance department on my machine, though... it took 29 minutes to do the million row example...

As "both" a developer and a DBA, I find the position that anyone looking to implement solid practices for testing and roll-out as being "in the way of progress" disingenuous,...

GROUPING() "inserts" extra lines into your query with subtotal rollups, which is why that row has some many NULLs on it. So it never touches the detail records, which...

It seems rather extreme - but could it be parameter sniffing?

Ken Henderson (you will be missed) described it rather well here:

http://blogs.msdn.com/khen1234/archive/2005/06/02/424228.aspx

There's actually one level even higher, or at least used to (since the term has mysteriously disppeared). The Microsoft Fellow has a lot of the same requirements as this,...

Since you're in 2000 - you're going to need to use something iterative to go out and pull in the various levels of children.

You seem to be describing...

Oh I know - I'm not even going to comment on the cost-appropriateness of those licenses (especially the Volume licensing.) I was just noticing the one feature you can...