Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-03-02 : 08:47:08
|
| Rajan writes "I'm working on a Reports and I need to combine data from multiple rows (with the same EventDate) into one comma separated string. This is how the data is at the moment:EmployeeID EventDate2309 2005-10-01 00:00:00.0002309 2005-10-01 03:44:50.0002309 2005-10-01 08:59:00.0002309 2005-10-01 09:29:44.000I need it in the following format:EmpID EventDate EventTime2309 2005-10-01 00:00:00,03:44:50,08:59:00,09:29:44There is no definite number of EventTime per Employee for a particular EventDate. And i don't want to use Iterative Methods.Thanks & RegardsRajan" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Combining multiple rows into single column 
