DSXchange

HOW TO CONVERT VERTICAL ROWS INTO HORIZONTAL COLUMNS
LIKE
SOUCE IS
ENAME
ADI
SASI
KUMAR
VAMSI



TARGET IS
ENAME
ADI,SASI,KUMAR,VAMSI

adisheshu.dwh - you have managed to break an incredible amount of DSXchange forum rules and recommendations in a single post.

- Please post meaningful subject lines, "HI" is not a good choice.
- You posted in the "FAQ Discussion" forum, which is meant for frequently-asked-questions and their answers.
- You posted in all UPPERCASE, which is generally considered to be shouting.
- You did not use the search functionality prior to posting.

Please post your qeustion again in the appropriate forum, most likely either Server or Parallel extender, depending upon which product you are asking about as the answers will depend upon the type.

This is what is called a "vertical pivot" and many others have posted the same question as yours, and have had it answered. Please search for "vertical pivot" and look at some of the response threads, such as this one