weitzera (12/2/2010)

---

This is very similar, if not identical to a sql challenge posted a while back. check out the discussion related to it, I think you'll find some good...

OK It seems that the code will work I tried to set up tables and all to just try to see if such a query is possible. this opens a...

Hmm.

Since I don't have the data can anyone clarify if this would work?

@DECLARE @Avg money

Select Top 1 @Avg = ((OpeningCost*OpeningStock) +(Price * Qty) / (RStock + Qty)) FROM SnapShots...

You could write a parse Script.

match the texts with if statements and write them in another file as you would like them.

It maybe faster than manually typing everything out.

GSquared (12/2/2010)

---

You can definitely keep point-in-time pricing in an SQL database. You'd just have a table with, for example, and item ID and a price and an effective date....