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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-04 : 09:42:00
|
| Ananth writes "Can We write generalized Partition Function in SQL 2005? For Example, I am created Partition Function for one year of Transactions. i.e., January to December based on Transaction Date. It works for this year 2006. When 2007 comes, how can we partition the table. Can it be manual procedure for each and every year? Or Can We generalize the procedure which works for all years. Thanks in advance Regards, Ananth" |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-04 : 10:48:45
|
| You need to post the code you've already written and look at the examples in Books Online. |
 |
|
|
hrishi_des
Yak Posting Veteran
76 Posts |
Posted - 2007-01-08 : 08:17:34
|
| U can do that by modifying the partition function, u need to write code for that... |
|
|
|
|
|
|
Partition Function in SQL Server 2005