• 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;-)