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)

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...

declare @test table (col1 numeric(10,4))

insert into @test

SELECT 34.0200 UNION ALL

SELECT 1232.0560 UNION ALL

SELECT 234.4400 UNION ALL

SELECT 451232.123

select * from @test

where col1 like '%.__[1-9]%'

This does do an implicit conversion...

CirquedeSQLeil (4/22/2010)

Thanks.

I like the comment he made...