Posted by Rob Smith on 12/20/05 23:34

Thank you for your response. I too needed to violate years of SQL
theory and flatten out a table into one row per person. Our need is to
easily include and exclude people for solicitation based on their role.
Your statement got reduced a half dozen views down to one and the
performance is better.

Thanks again!


*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: operand type clash
• Prev in forum: Re: time format error
• Thread view: Re: Getting data from multiple rows into one column

[Reply to this message]