"CAN'T BE DONE" -- Crazy boy
Well at first glance, that may very well be the answer, as in this thread:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100207
Now, this might not be what the OP is looking for, but if you employ a partitioned view, then yes, it's doable
cut and paste the sample code to see it in action
USE Northwind
GO
CREATE TABLE myTable99 (Col1 int PRIMARY KEY CHECK (Col1 BETWEEN 1 AND 10), Col2 varchar(50))
CREATE TABLE myTable98 (Col1 int PRIMARY KEY CHECK (Col1 BETWEEN 11 AND 20), Col2 varchar(50))
GO
INSERT INTO myTable99(Col1, Col2)
SELECT 1, 'x' UNION ALL
SELECT 2, 'y' UNION ALL
SELECT 3, 'z'
INSERT INTO myTable98(Col1, Col2)
SELECT 11, 'x' UNION ALL
SELECT...