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 |
|
dave.bodenheimer
Starting Member
5 Posts |
 Posted - 2011-07-08 : 10:37:36
|
| OK, I'm sure this is incredibly simple, but I'm having a brain lock.I have a table that contains several records for a given case. Here is a sampleCase Item1 ItemA1 ItemB2 ItemA2 ItemB2 ItemC3 ItemAI need to be able to query this table by case and return a string containing all of the items in that caseSo in my example, if I were to query case 1, I would want 'ItemA, ItemB' If I were to query case 2, I would want 'ItemA, ItemB, ItemC'I'm sure this is really simple and I feel like an idiot asking, but I would really appreciate the help!Dave |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
dave.bodenheimer
Starting Member
5 Posts |
Posted - 2011-07-08 : 11:01:22
|
| Thanks! created a udf to handle it. Thanks! |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-07-08 : 19:21:01
|
quote:
Originally posted by dave.bodenheimer
Thanks! created a udf to handle it. Thanks!
Why ? Didn't i refer you to a solution without UDF ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
Summarize data from multiple records in table