I don't think you can do that, but you could either have a job the does a merge split every week (which includes dropping files and filegroups and creating new ones. Or create a column that has 2 values (eg 1 or 0) and frequently do updates on the table to change the value so the record gets moved IF you partition on that column.

Rich

--------------------------
Sent from my BlackBerry Wireless Handheld


-----Original Message-----
From: Mahmood Jaffer (SoftLanding) <mssqldba-ezmlmshield-x76354249.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Fri Dec 28 00:03:44 2007
Subject: paritioning

Hello,

Is it possible to use a dynamic function in the partition function statement? I'd like to partition a sql 2005 table into two partitions containing active data (data < than one week old) and > 1 week. Is this even possible?

Thanks
Mahmood



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message is for the exclusive and confidential use of the addressee. Any other distribution, use, reproduction or alteration of the information contained in this electronic message, by the addressee or by any other recipient, without the prior written consent of the sender is strictly prohibited. If you have received this electronic message in error, please notify the sender.


MS Sql Server LazyDBA home page