Thanks for the reply.

Table variables can be handy if we want to capture more info other the error message, like some record which got failed, the user who tried to...

Did you migrated to 64bit environment from 32?

Whats the size of the TempDB and is it in the SAN Disk?

Can you please try dropping and recreating the indexes?

*/

Please execute the query and let me know whether what I understood was correct :).

You wanted to display record if the numberOFDays is 1 ( irrespective whether onHand<Quantity).

Also...

Can you please check in another SQL window with Actual Execution Plan on, the time taken and plan for running a normal select * on the bottom 2 tables, ...

Please add more info about the particular query.

I agree with BrainDonor. Try like this.

create table pkcon (id int,name varchar(20))

-- here i'm trying to add the primary key constraint

if exists (select 1 from pkcon where id is null)

...