No arrays. Some people use XML, but that can get messy.

If you go into a bit more detail on what you're doing, maybe we can suggest an alternative.

From what...

SELECT roll, MAX(sname)

FROM Table

GROUP BY roll

ORDER BY roll

Probably very easy, but I do need a bit more info.

For Roll 1 you have sNames of 'aa', 'bb' and 'cc' Why is 'aa' the one you want returning, not...

rbarryyoung (3/20/2008)

---

Gail, my understanding is that, in the abscence of statistics, the optimizer will, having nothing else to go on, order the predicates as they were ordered in the query...

Could you post the definition of cc_message and its indexes (assuming it is a table). Could you also give us an indication of how many rows are in the table...

This will get it for you. I don't know if there's a way to tie the name back to the creating SPID though. don't think so.

SELECT * FROM tempdb..sysobjects WHERE...

Can you post the execution plan for us please (saved as a .sqlplan file, zipped and attached)?

Could you post the table's create script, some sample data and expected output please.

See here - Forum Etiquette: How to post data/code on a forum to get the best...

Sure we can help. But first we need to know why the database is suspect. Please have a look in the SQL Server error log. There will very likely be...

Is it a permanent table you're getting that message for, or a temp table?

If permanent, check that auto_create_statistics is on for that database

Timestamp values are unique within a database

Books Online

---

Each database has a counter that is incremented for each insert or update operation that is performed on a table that contains a...

From what I remember, there are a number of requirements for indexing computed columns, regardless of what's in the column or what it's called. Similar to the requirements for indexed...

When you create a temp table, SQL server hashes the name so that there's...

I can confirm your theory. I've seen (On this forum in fact) a deadlock...