I have a table that specifies the year, and a quantity for each month, in the same row. I need to get a 12 month rolling average, which involves particular fields from one row, and addition fields from another, based on the sysdate. There are several tables that need to be joined to ensure I have the correct record. I am at a loss as to how to do this.
For instance, I need months 8 to 12 from row 1, and 1 to 7 from row two, to compute the average. Making it more complex is the month fields are not specified with month number, but as the month spelled out fully with a suffix. ie. sc_may_quantity. Thanks for your help.
January 31, 2008 5:38 PM
May 1, 2008 3:29 PM