|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Challenge
http://www.sqlmag.com/Article/ArticleID/93462/sql_server_93462.html
Cheers, -- BG, SQL Server MVP www.SolidQualityLearning.com www.insidetsql.com Anything written in this message represents my view, my own view, and nothing but my view (WITH SCHEMABINDING), so help me my T-SQL code. Not the first time I post to the wrong group, I'm afraid. <blush>
I know this looks like self-promotion, but honestly I meant to send this in a private newsgroup and didn't notice I was posting in the wrong place. Sorry about that, -- BG, SQL Server MVP www.SolidQualityLearning.com www.insidetsql.com Anything written in this message represents my view, my own view, and nothing but my view (WITH SCHEMABINDING), so help me my T-SQL code. Show quote "Itzik Ben-Gan" <it***@REMOVETHIS.SolidQualityLearning.com> wrote in message news:uK4xqwa1GHA.4312@TK2MSFTNGP02.phx.gbl... > http://www.sqlmag.com/Article/ArticleID/93462/sql_server_93462.html > > Cheers, > -- > BG, SQL Server MVP > www.SolidQualityLearning.com > www.insidetsql.com > Anything written in this message represents my view, my own view, and > nothing but my view (WITH SCHEMABINDING), so help me my T-SQL code. > > > Of course. It's the question that drives us... ;-)
-- BG, SQL Server MVP www.SolidQualityLearning.com www.insidetsql.com Anything written in this message represents my view, my own view, and nothing but my view (WITH SCHEMABINDING), so help me my T-SQL code. Show quote "ML" <M*@discussions.microsoft.com> wrote in message news:E62E98F8-3AE6-4798-960C-C48F78D8091F@microsoft.com... > Self-promotion or not, puzzles are made to be solved, right? ;) > > > ML > > --- > http://milambda.blogspot.com/ All the answers are out there but have no real purpose without the questions.
ML --- http://milambda.blogspot.com/ How ironic that I wrote this:
http://racster.blogspot.com/2006/09/rac-rank-this.html just before Itzik's new puzzle. Did I ask the proper question -:) best, http://racster.blogspot.com Show quote "ML" <M*@discussions.microsoft.com> wrote in message news:FCD812AA-8135-4879-958D-68465FD8C206@microsoft.com... > All the answers are out there but have no real purpose without the > questions. In the thread:
microsoft.public.sqlserver.programming Wednesday, September 13, 2006 Need Consecutive Query markc***@hotmail.com showed a brilliant way to get atleast really close to a DENSE_RANK() where column(s) don't exist to get it directly. I'll eat some crow because I didn't think it was possible to do this so easily. It's not quite Rac but it's really close :( :). Although my point remains a dense rank should be obtainable directly:) best, http://racster.blogspot.com  |
|||||||||||||||||||||||
Other interesting topics