And now we can officially close this thread!!

You could always use pivot.

But I don't find case to be hard to read.

Maybe it's a record, but I'd still like to know how it got fixed (if it ever did).

... and Gail is the one I would call to save my life with a problem like this. Can't ask for a better consultant.

Good luck!

LutzM (3/29/2011)

Please ask your tutor to rephrase this question. It will make it easier for you to google for an...

What happens when there's a < in the text?

Easiest is to use sp or parameterized queries.

I've had to take another path once in which case I made sure to double the apostrophes as well so they couldn't end...

I'd do while @@rowcount <> 0 and flush the exists.

I'd do a checkpoint every X loops.

I'd insert a waitfor for a coouple seconds so that transactions can run between loops.

However,...

We're not doing your homework, exam or interview for you.

Do the work yourself.

Seems clear enough to me. As longs as it runs in ms now I think you'll be fine. I wouldn't tune this any further unless this query...

Null is a "value". So it can be used in an index.

"value" is very loose here :w00t:.

It makes sens to use an index there if it helps that query...

And yes you need to had insert into before the final select.

I consider that step gravy since I don't know your data and not 100% sure that this is what...

It's a table with only 1 column. I have all numbers from 1 to 30 000 in there.

Just to disagree even more, here's a little log file I kept while I was converting @t to #t. It's starts with the baseline at 4+ M reads (after...

;WITH CTE_Names (name, Rank, Tickets) AS (

SELECT TOP 100

name

, ROW_NUMBER() OVER ( ORDER BY Name ) AS Rank

, 101 - ROW_NUMBER() OVER...