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 |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
 Posted - 2008-03-19 : 14:32:40
|
| I have a flat /derived table of orders that customers made, virtuallyorder_tbl( order_id,item_id,product_id,product_price,product_name,customer_id,customer_name,order_price,order_tax,order_date,order_year,order_month,order_day)and I would like to have:1.update on this derived table daily (how/what should I do - with triggers/jobs against the original tables?)2.create a view that would show: - by years the percentage of sold products - quarterly percentage of new customers / rebuyers / etc. - ...3. Thinking of making a cube in BIDS (with dimensions / measures)Any help is appreciated. :-) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 20:43:15
|
| 1. use job.2 & 3. looks like same thing with different means, cube will be quick for big fact table and more flexible. |
 |
|
|
|
|
|
|
|
update and designing view