(tatata9999@gmail.com) writes:
> Interesting idea, Erland, but it did not seem to work for me, maybe I
> didn't do it right? Only two variations.

We have only seen fragments and pieces of what you have been doing. It
would if you posted a create table statement for your table, insert
statements with sample data, and the desired result given the sample.
That makes it easy to develop tested query. Without that, we are mainly
guessing.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx