KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a query which outputs something like this: +-------+----+--------------+ | F_KEY | EV | OTHER_COLUMN | +-------+----+--------------+ | 100 | 1 | ... | | 100 | 2 | ... | | 150 | 2 | ... | | 100 | 3 | ... | | 150 | 4 | ... | +-------+----+--------------+ I'm sure that I've seen an aggregation function which turns it (using GROUP BY F_KEY ) into something like this: +-------+------------+--------------+ | F_KEY | ? | OTHER_COLUMN | +-------+------------+--------------+ | 100 | (1, 2, 3) | ... | | 150 | (2, 4) | ... | +-------+------------+--------------+ Means, it somehow "implodes" the values of EV together into one single field. How can I do this? Unfortunately, I don't remember the function's name. I'm using SQL Server. This is a simplification of my query: SELECT F_KEY, EV, OTHER_COLUMN FROM TABLE1 JOIN TABLE2 ON F_KEY = TABLE2.ID WHERE EVENT_TIME BETWEEN '2011-01-01 00:00:00.000' AND '2011-12-31 23:59:59.999' ORDER BY EVENT_TIME ASC Any idea is appreciated!
Tags (comma-separated)
Save Edits
Cancel