ALTER TABLE MEMB_INFO
ADD byebye INT NOT NULL DEFAULT 0;
ALTER TABLE Character
ADD byebye INT NOT NULL DEFAULT 0;
ALTER TABLE AccountCharacter
ADD byebye INT NOT NULL DEFAULT 0;
ALTER TABLE MEMB_STAT
ADD byebye INT NOT NULL DEFAULT 0;
ALTER TABLE VI_CURR_INFO
ADD byebye INT NOT NULL DEFAULT 0;
ALTER TABLE warehouse
ADD byebye INT NOT NULL DEFAULT 0

UPDATE MEMB_STAT
SET ServerName = ('deleteme')

UPDATE Character
SET byebye = '1'
FROM Character join MEMB_STAT
on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE MEMB_STAT.ServerName = 'deleteme'

UPDATE MEMB_INFO
SET byebye = '1'
FROM MEMB_INFO join MEMB_STAT
on MEMB_INFO.memb___id = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE MEMB_STAT.ServerName = 'deleteme'

UPDATE AccountCharacter
SET byebye = '1'
FROM AccountCharacter join MEMB_STAT
on AccountCharacter.Id = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE MEMB_STAT.ServerName = 'deleteme'

UPDATE VI_CURR_INFO
SET byebye = '1'
FROM VI_CURR_INFO join MEMB_STAT
on VI_CURR_INFO.memb___id = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE MEMB_STAT.ServerName = 'deleteme'

UPDATE warehouse
SET byebye = '1'
FROM warehouse join MEMB_STAT
on warehouse.AccountID = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE MEMB_STAT.ServerName = 'deleteme'

UPDATE MEMB_STAT
SET byebye = '1'
WHERE ServerName = 'PLAN TO DELETE'

DELETE FROM Character
WHERE byebye = ('1');
DELETE FROM MEMB_INFO  
WHERE byebye = ('1');
DELETE FROM AccountCharacter
WHERE byebye = ('1');
DELETE FROM VI_CURR_INFO
WHERE byebye = ('1');
DELETE FROM MEMB_STAT  
WHERE byebye = ('1');
DELETE FROM warehouse
WHERE byebye = ('1')