That makes sense.

The way I do that is generate a "breadcrumb path" for each node, using a simple recursive CTE. Pad the parent IDs with leading 0s, and either...

Formatted:

SELECT cal.datevalue,

DATENAME(DW, cal.datevalue) day_of_week,

ISNULL(flowon.sum_flow_on, 0) flow_on,

...

Michael Valentine Jones (12/28/2011)

---

GSquared (12/28/2011)

---

Michael Valentine Jones (12/28/2011)

---

GSquared (12/28/2011)

---

Michael Valentine Jones (12/28/2011)

---

I don't see how RCS would be a problem in a data warehouse\datamart application.

If there are no inserts/updates/deletes happening,...

David Moutray (12/28/2011)

---

RCSI wouldn't permit dirty reads, but it would permit non-repeatable reads and phantom reads. Since the required overhead for the Temp DB is significant, I want to...

ben.rosato (12/28/2011)

---

GSquared (12/28/2011)

---

If I'm reading it correctly, it's pretty much just a "Where in (values)" statement with as close to unlimited number of allowed values as they felt they could...

Evil Kraig F (12/28/2011)

---

Merry Christmas all. Disappeared for a week and only 2 pages on the Thread when I came back! Y'all were slackin'! Of course, I...

The difference between S and U is that multiple connections/transactions can take an S lock on data, but only one can take a U lock on something at a time....

drew.allen (12/28/2011)

---

I don't think it's that easy...

Are you in a position whereby you can "fall back and punt" on this?

This is definitely a case where a nested sets hierarchy will save the day performance-wise.

Here's some data...

drew.allen (12/28/2011)

---

There may not be syntax errors, but there are lots of logical errors. For instance, the table clean_cust_account_lcd_cancel_switch is queried three separate times when it looks like it...

Michael Valentine Jones (12/28/2011)

---

GSquared (12/28/2011)

---

Michael Valentine Jones (12/28/2011)

---

I don't see how RCS would be a problem in a data warehouse\datamart application.

If there are no inserts/updates/deletes happening, then there are no...

Hate to say it, but this is the Internet, and I don't open files that could contain auto-executable code from unknown sources.

Can you either post the code in the forum,...

No syntax error in that.

The usual:

SELECT columns

FROM tables/views/etc

WHERE criteria

ORDER BY columns

Can you post the stored procedure? If so, we can take a look at it and see if we can spot the error.

Exactly.

But if data changes matter to the business, it might be worth digging into. Might not as well. Depends on what they need, why they need it, and...