null (11/3/2007)

---

One of the goals is to email query results as html tables - which prevents the use of

xp_sendmail. However, the CDO method limits the body size to 8000 -...

The task sounds like text processing.

I don't see anything related to databases in it.

I believe T-SQL has nothing to do with it.

There are many other, more effective tools for text...

Once, when I gave up to convince developers not to use "sequence" tables...

If I understand you right yo need:

1) Insert result of your query into #Table with identity(1,1) column.

2) Insert (or Update) into static table from #Table, new Number will be MAX(Number)...

Does the WIndowsNT account running SQL Server have appropriate access rights to folder \\ServerA\share\ ?

I'm not aware about any fixed number.

And I don't think there should be one.

It's a job of optimizer to make an estimation for each available options and choose the best...

kannan,

what else your 1000+ lines code does what Vladan's code does not?

The only idea I have about dynamic index - it's absolutely useless thing!

Get rid of loop.

Then it would be faster to create a new table, populate it with rows you want to leave, drop FK's, drop old table, rename new table to "old table name"...

How many rows should be left after all?

Looks like correlated subquery.

Nor really nice as for me. 😉

mrpolecat (11/1/2007)

---

I have a simple query

select * from table1 where field1 = 'xxx'

There is a clustered index on the PK and a non clustered index on field1

The execution plan uses...

SET ROWCOUNT

Peter Larsson (11/1/2007)

---

No. You have different primary keys. So what is your mission with this? Leaving ORDER BY in a SELECT statement never guarantees the order to be the same...