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 |
|
VeselaApo
Posting Yak Master
114 Posts |
 Posted - 2010-11-16 : 10:19:12
|
| Hi,I have to find a way to approach this challenge:I have a table with 100 rows. Across the columns I have calculations that are based on the number of rows the table has (using the count(rows) function). I need to find a way to:1) Reduce the number of rows the table has (imagine that each row represents a date and I want to cut down the amount of time from 3 months to 1 month - 100 rows to 31 rows) .2) Once I update the number of rows, I need all table calculations that are based on this number to update automatically.Can anyone help me how can i achieve this?thanks |
|
|
TimSman
Posting Yak Master
127 Posts |
Posted - 2010-11-16 : 10:20:31
|
| What do you mean by "automatically"? |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-11-16 : 22:14:24
|
it will be easier for us to help you if you can post your table structure, sample data and expected result
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Update table's calculations as you remove rows