Wiki lists...

rodjkidd (6/16/2015)

---

From the comments;

Q: And where's TARDIS?

A: It's both too large and too...

Here's one for the hard-core Sci-Fi fans out there:

Size Comparison - Science Fiction Spaceships

Count me among 'em.

I've simplified your product table a little to concoct this example because I'm too lazy to build the requisite DDL and consumable sample data exactly as you've shown.

DECLARE @OldProducts TABLE

(

...

This might work too using sgmunson's setup data:

WITH AddRowNumber AS

(

SELECT *

...

Seems Dohsan gets the credit for that one. 🙂

reader97 (6/5/2015)

---

Hi every one, I am new to SSC . I have a table that has NO.OF WORKING HOURS for 30 days. I am trying to convert all the values...

Jeff Moden (6/4/2015)

---

Oh, be careful. I truly meant...

gacanepa (6/4/2015)

---

Hi everyone,

Here's the scenario. I have a table (let's call it MyTable) that consists of four fields: Id, Source, FirstField, and SecondField, where Source only takes one of two...

That's going into my table of Jeff Moden quotes.

ScottPletcher (6/2/2015)

---

For now you could create a non-persisted computed column you could reference in queries to get the "clean" number. Later you could make it an actual column by...

spaghettidba (5/29/2015)

---

dwain.c (5/28/2015)

---

On the CELKO ban, interestingly I just got a notification email the he posted to Jeff's article: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

But when...

On the CELKO ban, interestingly I just got a notification email the he posted to Jeff's article: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

But when I followed...

Definitely some interesting...

Not sure if you still need an answer to this, but here's a shot at it:

With Hierarchy (col1, col2) AS

(

SELECT 1, NULL

...