my customer wants a report to show quantities sold after a period of time.
3, 5 or ten days, etc.
I started by getting the MininumDate of every article in a seperate table.
Now he tells me: no, no, not the first time ever the article shows up
in the facttable is the startdate but the date when
for example 500 pieces are sold. :-(((
So the facttable looks like:
Article, Date,Quantity, Price, ....
I can imagine a procedure to go through all the factdata
and would develop this.
The point is:
Factdata is now 230 Million records, with 160.000 article in 3 years.
So I'm not shure how long this procedure will run.
Is there any procedure code I can use?
Is there sql syntax - perhaps using subqueries - I can try?
Any suggestions are very welcomed!
thank you in advance