Re: sql query syntax

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 Feb 2005 08:41:13 -0800
Message-ID: <1107362473.758677.10190@c13g2000cwb.googlegroups.com>

Yaron, I am going to give you the benefit of the doubt. I think you might want to reconsider my suggestion.

Your target data exists as multiple rows. You want one non-summary row to be returned. Pivoting can definitely accomplish this.

You want a single column from serveral. That seems to be a task that concatenation can be used to accomplish.

Put the two step together.

There are other ways to solve the problem, but the above is fairly simple to figure out and write as a single SQL statement. HTH -- Mark D Powell -- Received on Wed Feb 02 2005 - 10:41:13 CST