create table #t1(col1 varchar(200),col2 varchar(200))

insert into #t1 select 'john','trovolta'

insert into #t1 select 'trovolta','john'

insert into #t1 select 'carlos','moya'

insert into #t1 select 'john','candy'

insert into #t1 select 'candy','john'

delete x from

( select...

for 2005 this one shd work..

create table #t1(col1 varchar(200),col2 varchar(200))

insert into #t1 select 'john','trovolta'

insert into #t1 select 'trovolta','john'

insert into #t1 select 'carlos','moya'

delete x from

( select row_number() OVER...

It heavily depends on how much RAM you have and how many users are going to access, how much of data on your query..what kind of settings on SQL Server...

Hi terry,

Are you trying to find the name of the table associated with a particular index?

As per BOL 'id' on sysindexes maps to table name, so it find it easily.

Am...

while querying on sysindexes just try

select object_name(id) from sysindexes where name like ''

Silly but definitely makes sense

If you can afford to create an identity column/ transfer rows to an temp table

with identity column then this can work

create table #t1 ( id int identity(1,1) ,cid1...