Posted by Erland Sommarskog on 02/17/07 17:16

Rick (rickcool22@hotmail.com) writes:
> I would like to know how it is possible to make my problem below all in
> ONE query or stored procedure.

Since there have been two answers to your posts in two different newsgroup,
I abstain from trying to solve the problem, but I will only make to standard
remarks:

o Don't post the same question independently to multiple grops, crosspost
instead. This saves people from spending time on answering posts that
have already been answsered.

o The accuracy the answers you get can be improved enormously if you
include a) CREATE TABLE statements for your tables. 2) INSERT statments
with sample data. 3) The desired result given the sample. This makes
it possible to copy and paste to develop a tested query.


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