Turn the adjacency hierarchy into a standard many-to-many (joining the primary table back to itself), with a date-effective range in the join table.

When you build the CTE, you just have...

Jeff Moden (3/10/2011)

---

GSquared (3/10/2011)

---

I've used a variation on this solution for sorting before, and found that it works best if you pad numerical values with leading zeroes to a fixed...

Jeff Moden (3/10/2011)

---

GSquared (3/10/2011)

---

I've got a two-step script that can generate a nested sets "path" from an adjacency hierarchy, turning it into a nested sets hierarchy, using Cross Apply and...

Jeff Moden (3/10/2011)

---

Wesley Brown (3/10/2011)

---

I prefer to use a two column approach to build a tree instead of the single column style that you have to split, it doesn't scale...

You need Alter Object permissions to truncate, because of what it does to Identity columns and all that.

You might be better off skipping that step entirely. You can include...

I did this in SQL 2008. Used your table create and populate script, then:

;with Prizes as

(select *, ROW_NUMBER() over (partition by ProductName, Unit order by Value desc) as Row

from...

Yes. You just need to change the Like statement to include the Letter column as many times as you're looking for, and then change the Replace statement the same...

You'd have to rework the way you're calling the data in order to get that to work.

alen teplitsky (3/9/2011)

---

GSquared (3/9/2011)

---

alen teplitsky (3/9/2011)

---

the pro's of vmware is that you ship the entire instance to DR and just mount it on your DR vmware host and change the...

I've used a variation on this solution for sorting before, and found that it works best if you pad numerical values with leading zeroes to a fixed length, before sorting...

Removing data from a database won't make the files shrink. You have to actually tell it to shrink them to get that to happen.

Keep in mind that shrinking database...

Since you already have the letters (in your Numbers table), you don't need the CTE at all.

Change:

WHILE @@rowcount > 0

with Letters(Letter)

...

Ghanta (3/9/2011)

---

Thanks GSquared ... I had used http://www.sqlservercentral.com/scripts/Miscellaneous/31775/ but yours is even better as it takes care of median for even sets correctly. Thanks!

they want mode as well as subsets...

I would need to see the actual code you're using before I could tell you what to do to fix a syntax error.

There are advantages over a delimited list beyond just avoiding having to first concatenate the list together and then shred it back apart again.

First, the table variable has a defined...