Thanh Ngay Nguyen (1/16/2013)
I have a very clear idea on how to do either 1 or 2, but not both.
First you need to perform 1st then monthly job/manual intervention will move the data from partitioned table to destination table (partitioned or non- partitioned) , if you know both the step very well then whats the problem ?
Thanh Ngay Nguyen (1/16/2013)
Is that even possible to partition on top of partition?
What is this ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)