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 |
|
jandh98
Starting Member
10 Posts |
 Posted - 2010-11-03 : 08:53:56
|
| Is it possible to do this?Here's my current query:select DP.Number,BL.Agefrom dependentonly dpleft outer join birthdaylist bl on dp.entityid = bl.entityidOrder By DP.NumberMy results are:Number Age0100 200200 250200 37...As you can see, I have multiple numbers and I would like to group by them and get the following results:Number Age0100 200200 25, 37Can I do this?TIA!Heather |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-11-03 : 09:04:41
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Group but combine field