Cara create table virtual (membuat tabel virtual) di SQL Server

sintak:
create table #TR_PLA_tmp(claimno varchar(15), OURPLACODE varchar(15), PLAdate datetime)

Contoh script:
declare @claimno varchar(15)
declare @appdate datetime
declare @OURPLACODE varchar(15)

declare aku cursor for
select distinct claimno from TR_PLA
where (pladate >= '2000-01-01' and pladate <= '10/31/2011' ) and inputusername='Admin' --and claimno='MSC201110-0333'
order by claimno

open aku
fetch from aku into @claimno

create table #TR_PLA_tmp(claimno varchar(15), OURPLACODE varchar(15), PLAdate datetime)

while @@fetch_status=0
begin
select top 1 @OURPLACODE=OURPLACODE,@appdate=pladate from TR_PLA
where claimno=@claimno and inputusername='Admin' and (pladate >= '2000-01-01' and pladate <= '10/31/2011' )
order by appdate desc
insert into #TR_PLA_tmp(claimno,OURPLACODE,PLAdate) values (@claimno,@OURPLACODE,@appdate) --ngambil claimno dan osdate

set @claimno=null
set @appdate=null
set @OURPLACODE=null

fetch next from aku into @claimno
end
close aku
deallocate aku