Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Table partitioning Expand / Collapse
Author
Message
Posted Friday, July 20, 2012 5:31 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
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
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1332883
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse