Posted by Erland Sommarskog on 10/24/07 21:27

(thetaamommy@gmail.com) writes:
> Thank you much.
> This gives me 2 values, min and max.
> but, I will have a total of 4 persons on philosophy and it could be
> either 0 or 1 or 2 or 3 or 4 persons in philisophy.
> Is it possible to do a set operation for that ?

It could certainly help if you could produce a more extensive set of
sample data, also explain the logic to get the desired result.

But if I am guessing correctly what you are trying to achieve, the
answer is that on SQL 2000, your prospects are bleak, at as long as
there is no upper limit of how many persons there can be.


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

• Next in forum: Re: Cannot connect to SQL instance without port information
• Prev in forum: Re: Not Exists joining 2 tables
• Thread view: Re: Multiple rows combined into onerow and onecolumn separated by a special character

[Reply to this message]