uhhh... left? yeah? :-P:w00t:

It...

That's what I just did... just the title.

Well, all of the articles "written" by this "author" have been removed from the offending web site.

My bounce-back was sent to the email address that...

WayneS (4/22/2010)

---

Paul White NZ (4/22/2010)

---

Thank you Jason.

I have just received a very apologetic email from the site administrator. He has promised to take down the...

Paul White NZ (4/22/2010)

---

Thank you Jason.

I have just received a very apologetic email from the site administrator. He has promised to take down the offending...

This link http://www.hyderabadtechies.info/index.php/articles/39-articles?start=280...

While we're at it, compare this "article" with this article submitted to SSC[/url].

It's so cut-n-paste that in the...

@mister.magoo - excellent use of cross apply. I was thinking of using ROW_NUMBER(), but this looks a lot better.

Good job!

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

Luke L (4/22/2010)

---

Also, it seems that we have a bunch of lurkers watching the discussions while not participating. I hear of more and more everyday - and they all...

Jeff Moden (4/22/2010)

---

I wish they'd actually stop listening to most customers. Asking for things like enhancements to cursors just don't make sense to me. If they made things...

Since you're new to ranking functions, let me direct you to this recent article here on SQL Server Ranking Functions[/url].

There's no reason that you can't have multiple row_number() function calls...