joining multiple records to one record
Posted: Mon Dec 01, 2008 5:07 pm
I have the data in the below format
empno(field name)
7369
8765
9008
4507
I want it in this format
empno(field name)
7369|8765|9008|4507
how do we merge multiple records into one record as pivot does only horizontal in parallel jobs.
empno(field name)
7369
8765
9008
4507
I want it in this format
empno(field name)
7369|8765|9008|4507
how do we merge multiple records into one record as pivot does only horizontal in parallel jobs.