wouldn't be able to update database 🙁

Yes, it is the same query, I changed the condition, 'coz I needed reverse checkes....

My second Q is still unanswered:

Which way is better performace wise??

In my previous post: "Will all joins and where clauses be also applied on inner subqyuery for calculating CalculatedQty?"

I actually mean to say: all where and join clauses must also...

I tried this, it worked, Thanks Hari.

I do have few q now:

1. In real scenarions, I have many where and join clauses. e.g, I also want to filter lines

based on...

I need expect_date column value as output.

Expect_date of found table row.

Or the problem can be interpreted in words as:

My application creates Purchase orders for items with some quantity and these purchase orders have some Expect date. This date represents when...

e.g., my sample table and values are like:

create table purchase_orders

(order_ID uniqueidentifier,

Basequantity decimal,

Expect_date datetime)

insert into purchase_orders

values

(newid(), 20, '2008-07-31 00:00:00.000')

insert into purchase_orders

values

(newid(), 10, '2008-07-31 00:00:00.000')

insert into purchase_orders

values

(newid(), 10, '2008-07-06 00:00:00.000'),

now first...