db2waqte
Last Activity: Dec 24 '06, 07:01 PM
Joined: Dec 18 '06
Location:
-
Hi, I do appreciate your help but thats all they give me to come up with solution. thanks -
Need help in writing SQL stored procedure
Hi
I need to Write a stored procedure to extract the data from TBL_RAW_DATA
into TBL_12M_DATA in the correct format, using 12 months ago as the base date.
(for example, in September 2006, Base_YR is 2005 and Base_MO is 9.)
Thanks alot in advance.
Regards
Ed... -
Need help in SQL stored procedure
A customer is providing us with data in this format:
TBL_RAW_DATA:
Sku Customer 2004/01 2004/02 2004/03 2004/04
01A82G THIMBELS 0 0 0 0
01A82G FLAYRE 5 3 0 0
01A82G STACY'S 5 6 3 0
…
I need to extract a rolling 12 months of data, in this format:
...
No activity results to display
Leave a comment: