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 |
|
graabein
Starting Member
16 Posts |
 Posted - 2006-11-07 : 09:39:03
|
This should be easy but I can't figure it out. I have a DataSet that contains among other fields OpCode and OpText. Something like this:KCD02 | Hello | JimmyMCA10 | Howdy | HaroldMCA10 | Howdy | GaryTA761 | Hola | LolaI want to make a table where I group OpCode together with the belonging OpText and count of each like this:1 KCD02 Hello2 MCA10 Howdy1 TA761 HolaWhat cells do I need and what expression do they have?  |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-07 : 10:29:45
|
| select count(*), opcode, optext from mytablegroup by opcode, optextPeter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Group by and count