Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 In-Out Query

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-10-31 : 07:27:32
Mark writes "I have two tables - one has sales data the other has stock receipt data. I’m trying to align the product, quantity and sales date with the product, quantity and receipt date. I need to accumulate the receipts and decrement sales against the total available receipts – and it’s all constrained by dates.

Can anyone help me?"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-10-31 : 08:24:14
you provide this:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

we provide the answer

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -