Need Help to make SQL SERVER Query

[Arvind2004]

Hi I have a table CandidateTab Which contain the CandidateId and Skill fields and data in this table are in following format. CandidateID Skill --------------------------- 10 VB.net 10 ASP.net 10 C# 11 Oracle 11 SQL SERVER How can I make a query to get result in following format CandidateID Skill 10 VB.net,ASP.net,C# 11 Oracle,SQL SERVER Thanks Arvind

[dishanf]

Is not easy to get the result in one simple query! . At least you must write a cursor to doing this.. D!shan

[dishanf]

Try this also.. its little bit matching to ur prob.. OR is it ok to doing this through cursors? USE pubs GO DECLARE @title_ids varchar(150), @delimiter char SET @delimiter = ',' SELECT @title_ids = COALESCE(@title_ids + @delimiter, '') + title_id FROM titles SELECT @title_ids AS [List of Title IDs] D!shan

[Arvind2004]

THANKS,I will try it Arvind Arvind