phoeneous (7/10/2012)

---

I can retrieve the results just fine, it's when I have to do the sale.DollarX summation that is a problem.

See attached screenshots.

Notice that sale.Dollar5 is $50 and the date...

Woot! Happy that helped you both. Was a somewhat weak explanation, but apparently got the message across.

Your query doesn't match the sample data. That said you're on the right track. You just didn't get the cross apply structures quite right.

Assuming you do it...

If you're curious about what a data warehouse is, try this wikipedia entry:

http://en.wikipedia.org/wiki/Data_warehouse

That said - this isn't something you just pick up in a day or two. Your best...

Wait you're starting with all three tables, not BUILDING the third table. That's much better. Never mind my previous post.

I think hector is on the right track. ...

EDIT: misread the requirements at first - disregard this post.

******************************************************

That does paint a better picture on a logical basis, seems to expose another issue, which is that you're...

Using the identity as a clustered index isn't going to help you with your heavy deletes. in fact it seems to guarantee that the space used previously will NOT...

What relates the header table to the details table?

Given what you're describing it sounds like you need to put it in as a correlated sub-query. Something like (this is...

Please don't mind Joe - he must be late for his anger management class. He's certainly not representative of the rest of the fine posters on here, so try...

cfradenburg (6/27/2012)

---

GSquared (6/27/2012)

---

There's a big difference between telling a user "don't try to service your TV yourself, there are parts in there that can kill you, and you don't know...

jbnv (6/26/2012)

---

patrickmcginnis59 (6/26/2012)I'm pointing out that you have not addressed the free market response to a visibly bad actor. There very well could be an answer here, thats why I'm...

Lynn Pettis (6/25/2012)

---

Take two days...

Brandie Tarvin (6/25/2012)

---

Doesn't matter which school we get our personal beliefs about Nullability from. What matters is how SQL Server treats the datatypes. Given that SQL treats Varchar(1) as a...

GSquared (6/25/2012)

---

Actually, if you define "NULL" as "unknown value" as opposed to "no value", then one could define a nullable char(1) column as "we may not know what value it...

GilaMonster (6/25/2012)

---

One byte in the case of a...