Re: Help writing SQL query

Barry Bulsara wrote:

>>BTW: Why can't the design be fixed? You have to realize that this is
>>going to bite you on the posterior every single time you try to use it.

Then forget the query.

Create the target table and write one or more SQL statements, or a stored proc, to transform the data.

When you ask for a single query you make the problem far more difficult.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)