http://msmvps.com/blogs/robfarley/archive/2007/01/03/removing-all-the-rows-bar-one-per-customer-from-a-table.aspxI stumbled upon James Green's post about T-SQL and couldn't help but post about it. It's not that I want to blog about his blog, but rather I want to jump up and down about the fact that he's missing one of the best things about SQL2005 - the OVER() clauseenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://msmvps.com/blogs/robfarley/archive/2007/01/03/removing-all-the-rows-bar-one-per-customer-from-a-table.aspx#470362Fri, 05 Jan 2007 02:40:59 GMTd67277c4-116b-43f1-b688-e9ef184ea916:470362James Green <p>Nice one Rob :-) &nbsp;Good solution...</p> <p>The thing that motivated me to post that was how, when presented with the problem I jumped down the codegen path because there was a lot of code gen in my life at the time - hope I didn't give the impression I thought it was the most technically beautiful solution :-) </p> <p>Like i said, I was weak - trying to kick the habit ;)</p> <p>Best regards,</p> <p>James</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=470362" width="1" height="1">http://msmvps.com/blogs/robfarley/archive/2007/01/03/removing-all-the-rows-bar-one-per-customer-from-a-table.aspx#466674Wed, 03 Jan 2007 09:54:14 GMTd67277c4-116b-43f1-b688-e9ef184ea916:466674frankarr - an aussie microsoft blogger<p>James Green ponders How to know if no one is reading your blog... Adelaide based Arsenal fan (not to</p> <img src="http://msmvps.com/aggbug.aspx?PostID=466674" width="1" height="1">http://msmvps.com/blogs/robfarley/archive/2007/01/03/removing-all-the-rows-bar-one-per-customer-from-a-table.aspx#466669Wed, 03 Jan 2007 09:51:16 GMTd67277c4-116b-43f1-b688-e9ef184ea916:466669frankarr - an aussie microsoft blogger<p>James Green ponders How to know if no one is reading your blog... Adelaide based Arsenal fan (not to</p><img src="http://msmvps.com/aggbug.aspx?PostID=466669" width="1" height="1">