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 |
thanksfor help
Posting Yak Master
106 Posts |
Posted - 2009-06-05 : 13:21:48
|
HiI need to find the growth percentage between previous qtr and current qtr weeks. there is time table with date,month,qtr, qtr_week, year.It is joined with fact table with timeid.(amount of current qtr - amount of previous qtr )/ amount of current qtr where previous qtr's week_no = current qtr's week_noany suggestion will be helpfullThanks in advance. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-05 : 13:43:10
|
can you please post tables involved with some sample data? |
|
|
|
|
|