Vertical data to horizontal data

[fajitapete]

I have a table that stores several pieces of data. What I would like to do is create a view that represents this data as a single 'row'.

Other than the ugly multiple step process is there an elegant way to accomplish this


thanks in advance

pete

 

[sunila7]

Hi,

I think u r looking for crosstab queries... search for cross tab queries in this forum... u will get some samples to do it...

Hope it helps

Sunil