how to get the primary keys and display it horizontally?

sample results: <MRNID=10002><VesselCode=VSL1>

wherein MRNID and VesselCode are primary keys of the table.

What do you mean by "horozontally"

<MRNID=10002><VesselCode=VSL1>

This is horozontally.

<MRNID=10002>
<VesselCode=VSL1>

Would be vertical. Can you be a bit more clear?

|||

do you mean pivoting the table

well sql 2k5 has a pivot keyword