I consider it myself.

IN is '=' and NOT IN is '<>'

Optimyzer is right.

Please, consider a question. Can you write anywhere

declare @Tmp table(id int)

insert into @Tmp values(1)

insert into @Tmp values(null)

select * from @Tmp where...

I do not know. But I think improvements of T-SQL is powerfull. Now we have recursion in our queries! We can exec select ... from MyTable inner join MyFunction(MyTable.Field). Notifications!!! And so...

For this query

Select a

From @t1

Where a not in (select b from @t2)

optimizer generats next plan "((@t1.a = null or @t2.b = null) or @t1.a = @t2.b)"

and this query

declare

There is no any query. But there is many ways. One of each is build tree in the table with triggers. I never explore it, but i think it possible.

If...

if object_id('tmp') > 0 drop table tmp

create table tmp(id int, parentid int, code varchar(20))

insert into tmp values(1, 0, '123')

insert into tmp values(7, 6, '129')

insert into tmp values(2, 1, '124')

insert into...

give me your email

in sql 2000. Wait a moment please, i get you example.

You have to write a recursive function

But I think more powerfull to change insert algorithm. For example, create INSTED OF trigger or create a sp wich do insert or update to child table with additional fileds(item_subno1 and...

Oops! Instead of smile picture ')'

declare @master table(item_no int, item_flag varchar(1))

declare @child table(item_no int, item_subno varchar(1))

insert into @master values(1, 'Y')

insert into @master values(2, 'N')

insert into

Does item_subno contains all alphabet?

select item_no, item_subno_1 = case when item_subno = 'A' then item_subno end, item_subno2 = case when item_subno = 'B' then item_subno end

Check the Maximum worker threads eith EM. Maybe you have to increase it.