I would just Binoogle "sql server data warehouse example". You will find some examples of simple projects designed to help people learn how to build these. It is probably a...

You say "folderol" I say "flexible", let's call the whole thing off. 😛

jeandlauro (4/29/2014)

---

date 2 is the rolling sum of date 2 and date 1 by type

rolling(date 1, type a) = (date 1, type a)

rolling(date 2, type a) = (date 1,...

Actually in my system I wouldn't have all this nonsensical effort. I have a view named cteTally so I never have to build all that stuff. Assuming I have a...

ArtoisBB (4/29/2014)

---

I don't think I have been very clear.

I have an audit table that I want to use in order to monitor when data was last inserted into certain tables....

jeandlauro (4/29/2014)

---

I am looking to create a computed column for on the fly reporting. The query above only serves to show the output of what is needed, not how I...

GAH!!! I always forget about SSRS since we don't...

Eirikur Eiriksson (4/29/2014)

---

Sean Lange (4/29/2014)

---

What I don't really understand here is what is the point of this? This data is pretty much unusable because you have no way of putting...

SQLSteve (4/29/2014)

---

I never knew you shouldn't? Is this a bad thing to do?

It is only for a couple of services which have externally facing customer websites as a front end...

Only this time my friend. 😎

Don't do this. You are going to fight this battle until this is replaced with another approach. You will never keep your aggregate table accurately in synch with the other...

SQLSteve (4/29/2014)

---

What is everyones view on accessing SQL data which is stored on SQL instances in the DMZ via management tools on your local desktop?

Would you put a rule on...

You can do this using a tally table. Please post ddl and sample data in a consumable format...it makes it a lot easier for us to work on your issue...

Take a look at the links in my signature about cross tabs, specifically the second one about dynamic cross tabs. I am pretty sure this is what you are looking...

Whenever I see this type of request I have to ask, what are trying to accomplish here? What can you gain by knowing how much storage is consumed by each...