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.
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 handAny 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 data3. The query you have so far4. 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. |
|
|
|
|
|