SELECT STUFF((SELECT ',' + Skill FROM table WHERE dateTimefield = t.dateTimefield FOR XML PATH('')),1,1,''),... other columns
FROM table t

quote:

---

Originally posted by visakh16

you can do something like

SELECT STUFF((SELECT ',' + Skill FROM table WHERE dateTimefield = t.dateTimefield FOR XML PATH('')),1,1,''),... other columns
FROM table t

Would that not just give me a column with all the skills that were added at the same date/time?

The code you suggested still shows the same data on multiple lines.

I already use code similar to that to achieve that very same result.

I need to be able to only show 1 line per date/time that a skill change occured.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---