Table partitioning

  • Please help me with this cumbersome partitioning scenario

    Need to partition a table based on following status value of a column - A,B,C,D

    I want three partitions:

    Partition1 --> Status Value (A,C)

    Partition2 --> Status Value (B)

    Partition3 --> Status Value (D)

    How to do this?

    I don't want to create a separate Partition for status value A and C

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

Viewing 0 posts

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