And I'm still waiting for a well reasoned question that demonstrates you have taken the time to read about Dynamic SQL in Books Online.

RBarryYoung (10/2/2009)

---

Luke L (10/2/2009)

---

Matt Whitfield (10/2/2009)

---

When I was at school there used to be a game called 'Betrayal at Krondor' - where you would meet people as you travelled around....

heh, I was pretty sure that is who you meant. Looking at mine I can see how you didn't.

Sorry, either or, not both. Please go for the latter and do some research first. I find that helps me learn and remember better than someone just handing...

Okay, abbreviated response, should have written that such that you (Jeff) would have known it was dirrected to the OP. Sorry. I was just adding additional info to...

Okay, your choice. We can just give you the answer and hope you learn something, or we can direct you to other resources so you can to some reading...

And that assumes that the value in RANK can have duplicates. That wasn't discussed and the sample data didn't have that problem.

Considering the forum it was posted, and the content, I don't have a problem. Of course...

If your web sites are internet facing, you either need per processor licensing or you may want to look at the web version of SQL Server.

First thing I'll do is point you to BOL (Books Online, the SQL Server Help System that can be accessed by pressing the {f1} function key while in SSMS).

You want...

Alvin Ramard (10/2/2009)

---

I can't read it either!!!

Lynn, the link is not working for me. It tries to take me...

Alvin Ramard (10/2/2009)

---

I can't read it either!!!

Lynn, the link is not working for me. It tries to take me...

Good to know. Hopefully when we get thereI'll still remember. 😉

Okay, here's an I can't read moment. 😛

The link to the aforementioned article is located in my signature block below. It is the second article.