Hi All,
Anyways, I figured it out using Stuff funtion with For XML path I got the answer Just for one column field
with Programmers in single cell (comma sepearted Prgrammers name) and Clients which happened to appear in Single cell instead appeared in individual cell ...like below
ProjectNO. Prjtname Programmers Client
01 ave dee, law, amy zica
01 ave dee, law, amy rowan
Any suggestion or examples with (Stuff + For XML path) using individually with each(2 or more ) column... I had applied STuff+FOR XML path for both Programmers and Clients.