Luis Cazares (2/26/2015)

---

Sean Lange (2/26/2015)

---

Stewart "Arturius" Campbell (2/26/2015)

---

Sean Lange (2/26/2015)

---

BWFC (2/26/2015)

---

Sean Lange (2/26/2015)

---

There was no alternative other than 42 given the context of the question. I didn't even read the...

Stewart "Arturius" Campbell (2/26/2015)

---

Sean Lange (2/26/2015)

---

BWFC (2/26/2015)

---

Sean Lange (2/26/2015)

---

There was no alternative other than 42 given the context of the question. I didn't even read the question before answering. Of...

That isn't what Laurie meant. She really was asking if you...

BWFC (2/26/2015)

---

Sean Lange (2/26/2015)

---

There was no alternative other than 42 given the context of the question. I didn't even read the question before answering. Of course my soccer jersey has...

There was no alternative other than 42 given the context of the question. I didn't even read the question before answering. Of course my soccer jersey has that number and...

Excellent. Glad you were able to modify your code to incorporate this logic...

storemannequin (2/25/2015)

---

I'm sorry, I'm trying to follow all the instructions but lost on how to create the test data for you. All that I'm trying to create are two...

I can help you but you will have to provide more details first:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO...

patrickmcginnis59 10839 (2/25/2015)

---

Sean Lange (2/25/2015)

---

Hi and welcome to the forums. I see what you are trying to do here but I would suggest that you should avoid nesting views like...

sku370870 (2/25/2015)

---

Sorry this has got so complicated. I understand the way you have suggested to determine whether StageBase is true. If we go past that and just consider this:

CREATE TABLE...

sku370870 (2/25/2015)

---

Thanks for your reply. Adding a bit more to your code ...

This is what I really need to be testing.

0, 3, null ... is no good ... the...

OK I sort of think I get what you are trying to do. I added another set so you have one group that "fails".

CREATE TABLE #tblTemplateBlocks

...

storemannequin (2/25/2015)

---

I am tying to work on a small piece of the pie here with this code but it doesn't work as desired -- are there any glaring errors here?...

I didn't look at the new sample data until after you posted Luis. I assumed this was the very common "I have data that is mangled all over the place...

Excellent job posting ddl and sample data. I can't even begin to wrap my head around what you are trying to do here. What are these subsets? Where do they...