Posted by Erland Sommarskog on 02/18/07 10:44

Sjef ten Koppel (sjeftenkoppel@home.nl) writes:
> Oops you are fast! thank you.
> I could send you a create sql but I don't know how to extract sample data
> from my db see att.

It does not have to be real-world data, you could just fill in some
sample data, and tell us what the result you want from the sample. That
helps to clarify your question.

But did not the query that Macro posted fit your needs?


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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]