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]
create view [allpartitions] as
select * from [partition1]
select * from [partition2]
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!
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"