Um.... aren't those both the same link?

Ask him how it is supposed to do that? Fewer rows will fit on a page, so arguably...

I've set mine up where the primary key consists of both columns (uniqueness) and then make one nonclustered key with the columns reversed (It is automatically a covering index). ...

If you can run your script from SMSS, try this:

Tools\Options\Query Results\SQL Server\Results to Text ... then choose your options.

At least that's what it is in 2008. I can't...

It means Ni?

Does it always?

It is a mystery.

Do a quick search at SSC (search function is to the upper right) and you will find plenty of examples of how to handle this. The key terms...

We forgive you for agreeing with us, PP 🙂

I apologize to Barry for agreeing with him.

It's a funny word. I can't understand it. What does it mean? 😀

Hearing none opposed, the motion carries by acclamation.

So say we all.

Thanks for posting back your final solution, kabaari.

... and mine runs faster.

Game, Set and Match 😉

Paul and Matt,

I sincerely hope I wasn't too offensive.

As I said, it wasn't personal, I speak only for myself, and nobody else may mind at all....

Great, just great. Now I've got to clean spam off the water cooler..... 😉

Speaking only for myself, I resent this intrusion into what is normally a...

You're welcome, Jeff. You will find "PARTITION" under ROW_NUMBER() in books online. If you do a generic search on "partition", it will take you...