select * from yourtab

except

select top(10) * from yourtab

Spandan Buch

create table #aa

(

id int identity(1,1),

col1 varchar(30)

)

insert into #aa(Col1)

select col1 from yourtable

select * from #aa where id>10

Spandan Buch

As you said earlier "AUTOINCREAMET" is autoincrement no Correct?

IF OBJECT_ID(N'tempdb..T') IS NOT NULL

DROP TABLE #T ;

CREATE TABLE #T

(Col1 VARCHAR(10),

...

Check the datatypes... you seem to be fond of varchar(max). Also equality criteria is missing between twotables

A small tip

1. there are couple of RID lookup's try creating Covering indexes if possible.

2. I saw a table scan if this can be eliminated

3. there is a index...