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 |
|
associate01
Starting Member
3 Posts |
 Posted - 2007-09-18 : 12:16:21
|
| Quick, hopefully simple question--when you have multiple columns in a GROUP BY statement, how does SQL Server execute them? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-09-18 : 12:18:37
|
quote:
Originally posted by associate01
Quick, hopefully simple question--when you have multiple columns in a GROUP BY statement, how does SQL Server execute them?
What does that mean?It has to incur a sort and combine the values, and perform an scalar activity on the other columnsFunny thing is that the results won't nesseciarily come out sortedBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
|
|
|
Execution of GROUP BY