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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2007-09-01 : 05:51:35
|
| Thanks Jeff for the wonderful article. You not only helped in understanding derived tables but also showed how one should approach writing a query - one step at a time. Eagerly waiting for your next article. |
 |
|
|
binor
Starting Member
1 Post |
Posted - 2007-12-09 : 17:07:26
|
| Thank you very much for this so demonstrative article!"The virtual primary key of a SELECT with a GROUP BY clause will always be the expressions stated in the GROUP BY."I've never thought about grouped Resultsets this way. It's so much clearer now. :) |
|
|
|
mehrandvd
Starting Member
1 Post |
Posted - 2008-09-07 : 11:30:51
|
| Wowww, great article... It really helped...Thanks... |
|
|
|
kkebero
Starting Member
1 Post |
Posted - 2009-02-02 : 01:35:39
|
| Wonderful article!!! Clearly demonstrates the concept behind join result sets, GROUP By scenario and derived table usage. This should be the norm/way to explain fundamental concepts.Thank you so much, Jeff. Hats-off!! |
|
|
|
dnovak
Starting Member
1 Post |
Posted - 2013-10-02 : 11:17:47
|
| will a question still be answered here? |
|
|
|
|
|
|
Article: How to Use GROUP BY with Distinct Aggregates and Derived tables