Hello,

I have a simple SQL statement below and need it changed such that the data comes out horizontally rather than vertical so that a lookup table can be created. Below is the statement and sample output. To test a simple temp table could be created with dummy data:

SELECT PERSONNUM, PERSONFULLNAME, CUSTOMDEFNAME, CUSTOMDATA, PERSONID, CUSTOMDATADEFID
FROM VP_PERSONCUSTDATA


Output:

1 Test, Steve Letter A 2 1
1 Test, Steve Number 1 2 2

Would like to see this:

I'd like the 5th field holding A and 1 to be horizontal (i.e A 1 on the same line - not 2 different lines)

Thanks,

Steve