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
 General SQL Server Forums
 New to SQL Server Programming
 Aged Inventory

Author  Topic 

swilliams52
Starting Member

1 Post

Posted - 2014-07-29 : 23:16:43
I'm new to SQl so go easy...

I am trying to create a report that placing inventory on hand into aging buckets based on transaction data.

The aging buckets I would like begin at 0-3Months, 3-6Months through to the final 12Month +

I have sumarised monthly transaction views as follows:

per_out# : outgoing sales (where # represents curent month less #)

pur_# : Incoming purchases (where # represents curent month less #)

qty : current stock on hand


Any help apreciated and if you need further information let me know

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-07-30 : 08:08:59
To get help, please provide:

1. CREATE TABLE statements for the tables involved.
2. INSERT INTO statements to populate the tables with test data
3. The query you have so far
4. The output you get executing your query against the test tables created in steps 1 and 2)
5. The desired output from a correct query.
Go to Top of Page
   

- Advertisement -