[gymratz]

Each "Travel_Visit" has a start/end time, and person doing the visit (Emp_ID).
I have a foreign key of "Travel_ID" in this table, as each "Travel" can have multiple visits.

I need to pull a summary that takes the min date, max date, and lists all employees related.

I have the first part:

Select
	Min(TV.Start_DateTime) as [Start],
	Max(TV.End_DateTime) as [End]
From Travel_Visits as TV
Where
	TV.Travel_ID = '11'

But how do I list all employees in the same column separated by commas?
The query should only return a single row and 3 columns (the two I have above, and the third with a list of employees.

[xerxes333]

I don't think its possible without using a sub-select to build the string

[baavgai]

gymratz, on 26 Mar, 2009 - 12:05 PM, said:

But how do I list all employees in the same column separated by commas?

Nope. Database store and retrieve data, they don't obfuscate it for our viewing pleasure; that's what report writers are for.

You could write a user defined function to return a string, given an id. There's also a trick with SQL Server using coalesce, but you're not going to get with just a select.

[gymratz]

That is what I was afraid of - guess I get the data with SQL and then use vb.net to make it look pretty .

Thanks guys!