Partitioning column value range based on master table field?

  • I want to partition my detail table (SQL Server 2008) based on a date field (monthly data i want to partition). But the issue is i don't have a date field in the detail table, but only one int field which is a reference key to the master table which has the actual date field. So basically the detail table has integer values which i need to partition. See the structure below.

    Master Table

    MKey, Month

    1 '1/1/2010'

    2 '2/2/2010'

    4 '3/3/2010'

    8 '4/4/2010'

    Note : The value of MKey may not in the sequence as it's an identity column.

    Detail Table

    Mkey, Other columns

    1,--

    ://millions of records

    1,--

    2.--

    :

    2,--

    4,--

    :

    4,--

    8--

    :

    please help to partition the detail table based on month, ie (Mkey column). Or suggest some workarounds. (basically i need to partition all the unique MKey values in the detail table)

    Thanks in advance!

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply