how to show row wise record column wise

[mohd imran abdul aziz]

Hi All, i am using sql server 2005. in a table a record is entered as product1 , status1 ,product2 , status2 , product3 , status3 in a row now i have to display it as product1 status1 product2 status2 product3 status3 how can i do it . please help.

regards imran khan

[pmarfleet]

Use the UNION operator to concatenate the results from multiple select statements. BTW, your table design indicates that further normalization of your database is required. Unless there is an exceptional requirement to set your table up in this way, you should only have 1 Product field and 1 Status field.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush