displaying name-value pairs

[jagdeep]

Hi..

I am returning name value pairs from sp like
name value
---- ------
favColor Red
favDrink Pepsi
favAnimal Cat

Can i write a sp to convert name into row headers

favColor - favDrink - favAnimal
Red - pepsi - Cat

also, name may have multiple languages corresponding to them

Thanks in advance

Regards - Singh

http://Jagdeep.8m.net

 

[swampBoogie]

Make a search for crosstab queries.