Hi

I am a little confused about the examples listed and the use of temp tables etc. In classic partitioned views I would do something like:

create table [partition1] <...> filegroup [disk1]

create table [partition2] <...> filegroup [disk2]

create table [partition3] <...> filegroup [disk3]

then:

create view [allpartitions] as

select * from [partition1]

union all

select * from [partition2]

union all

select * from [partition3]

etc.. and of course be "federated" if the tables are on different servers. I cant work out from your examples where you are doing this?

I did just complete a 68hr week so I am probably half asleep!

Cheers

Ck