DBA

if object_id('tempdb..#A') is not null drop table #A if object_id('tempdb..#B') is not null drop table #B create table #A ( id int identity , aCol1 varchar(10) , aCol2 varchar(10) , deleteYN tinyint ) ----10 Rows Insert insert into #A values ('a011', 'a012', 0) insert into #A values ('a021', 'a022', 1) insert into #A values ('a031', 'a032', 0) insert into #A values ('a041', 'a042', 0) insert int..