|
|
|
SSCrazy
Group: General Forum Members
Last Login: Today @ 3:45 PM
Points: 2,937,
Visits: 1,692
|
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 4:24 AM
Points: 1,230,
Visits: 420
|
|
I enjoyed this question (even though the clause is being phased out!) as it was something I wasn't aware of, and it made me go off and research the subject. Now I understand.
Tom
Life: it twists and turns like a twisty turny thing
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Today @ 3:45 PM
Points: 2,937,
Visits: 1,692
|
|
hodgy (8/4/2008)
I enjoyed this question (even though the clause is being phased out!) as it was something I wasn't aware of, and it made me go off and research the subject. Now I understand.
Tom
Thanks, Tom!
And my apologies to everyone for the lousy formatting of the replies. All "&&"s were supposed to be replaced by line feeds, but that somehow didn't quite work out as expected. I've sent an email to Steve Jones, asking him to correct this, but given that it's deep night in his time zone, I don't expect this to happen for at least a few hours more. 
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 888,
Visits: 282
|
|
All "&&"s were supposed to be replaced by line feeds, but that somehow didn't quite work out as expected.
I did wonder. My eyes were going a little blurry trying to find the correct answer! :)
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 1:59 AM
Points: 358,
Visits: 809
|
|
Story of my life....
...I've discovered a new feature, just as it's being deprecated!
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Today @ 12:27 PM
Points: 1,756,
Visits: 4,671
|
|
Don't feel bad David. You're not alone in this boat.
hmmmm ...... is it your turn to row?
Alvin Ramard
Memphis PASS Chapter
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Thursday, February 11, 2010 7:52 AM
Points: 3,465,
Visits: 976
|
|
|
|
|
|
Valued Member
Group: General Forum Members
Last Login: Tuesday, July 14, 2009 7:44 AM
Points: 57,
Visits: 29
|
|
| A very good question. Thanks for posting this.:)
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, September 17, 2008 11:14 PM
Points: 3,
Visits: 0
|
|
| Good question but can anyone help me where this is supports by SQL Server new version.
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Today @ 3:45 PM
Points: 2,937,
Visits: 1,692
|
|
archu_223b4u (9/17/2008)
Good question but can anyone help me where this is supports by SQL Server new version.
It's still supported by SQL Server 2008, even though it's on the list of deprecated features. This means that nobody can tell (except maybe a few Mircosoft employees, but they won't) whether this feature will still be available in the next version of SQL Server (2011??), and whether some lower compatibility setting will be required by then.
In other words - start investigating your code now, and if you use this feature, plan to replace your code somewhere over the following years. There's no rush, but you shouldn't postpone it either. And you definitely should not use GROUP BY ALL in new work.
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
|
|
|
|
