quote:

---

Originally posted by only4u.nikhil

I want to partition one table for archiving the records. In the current scenario there is “status” filed in the table which has two integer values say 1 and 2 ( 2 means Records to archive). I want to create two partitions such a way that primary partition will have all the records having “status” equal to 1 and secondary partition will have all the records having “status” equal to 2. How can I create partition function so that, records with status equal to 2 will be moved to secondary partition. Sample script is as bellow.
USE TestDB;
GO
--- Step 2 : Create Partition Range Function
CREATE PARTITION FUNCTION TestDB_PartitionRange (INT)
AS RANGE Right FOR
VALUES (2);
GO

But using this script, the records which have status greater than 2 are moving to the secondary partition. Kindly write me solution so that I can move records with status exactly equal to 2 to secondary partition. Thanks in advance

---