use DOMAIN_event
go

CREATE  table email_destination_bk
(
msg_stub ut_stub not null ,
acct_id  int not null ,
evt_stub  ut_stub not null,
evt_code nvarchar(20) 
)
create clustered index idx on email_destination_bk ( evt_stub)

CREATE  table email_source_bk
(
acct_id  int not null ,
evt_stub  ut_stub not null,
[ut_stub] ut_stub not null,
evt_code nvarchar(20) 
)
create clustered index idx on email_source_bk (  acct_id, evt_code)

---------------------------------------------------------------------------
truncate table email_destination_bk
insert into email_destination_bk
select ut_stub,acct_id , evt_stub , evt_code
from email_source_bk
where acct_id = 2000122
order by  evt_stub, acct_id



truncate table email_destination_bk
insert into email_destination_bk
select ut_stub,acct_id , evt_stub , evt_code
from email_source_bk
where acct_id = 2000122
order by   acct_id,evt_code

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

-- INSERT data into destination table
insert into email_destination_bk 
select ut_stub,acct_id , evt_stub , evt_code 
from email_source_bk 
where acct_id = 2000122 
order by   acct_id,evt_code 

-- SELECT data from destination table
select ut_stub,acct_id , evt_stub , evt_code 
from email_destination_bk

-- INSERT data into destination table
insert into email_destination_bk 
select ut_stub,acct_id , evt_stub , evt_code 
from email_source_bk 
where acct_id = 2000122 

-- SELECT data from destination table
select ut_stub,acct_id , evt_stub , evt_code 
from email_destination_bk
order by   acct_id,evt_code 

CREATE TABLE TestingInsertOrder (
	ID UNIQUEIDENTIFIER PRIMARY KEY,
	Filler CHAR(50)
)
GO

INSERT INTO TestingInsertOrder (ID)
SELECT TOP (50000) NEWID() 
FROM master.sys.columns a CROSS JOIN master.sys.columns b

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass