Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,271 through 30,285 (of 59,101 total)

RE: a very COMPLEX aggregation query

vinu512 (4/23/2012)
Guys...i think the OP should be using an SSAS Cube for this...won't it be simpler if the OP does that?
Since I don't use SSAS, would you mind showing us...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 28, 2012 at 10:10 am

#1480859
RE: please give me a solution for this request

capn.hector (4/23/2012)
SQLKnowItAll (4/23/2012)
Jeff Moden (4/23/2012)
capn.hector (4/23/2012)
+1 however i saw this same question as homework for one of my sql classes.
Interesting! Where did you take such a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 28, 2012 at 10:08 am

#1480858
RE: please give me a solution for this request

SQLKnowItAll (4/23/2012)
Jeff Moden (4/23/2012)
capn.hector (4/23/2012)
+1 however i saw this same question as homework for one of my sql classes.
Interesting! Where did you take such a class?...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 28, 2012 at 10:06 am

#1480857
RE: Replacement for Cursors

vinu512 (4/27/2012)
Thank you Mr. Moden.
I've just started as a DBA(a while back) and have no idea where I will end up with it. But I am definitely loving what I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 28, 2012 at 9:46 am

#1480856
RE: need help to customise my T-SQL

idyana (4/28/2012)
Kindest dwain.c,
Whatever people said about your solutions, I dont care. For me, you are the best. You have helped me. they do not help but criticize only
For me, you're...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 28, 2012 at 9:37 am

#1480855
RE: Microsoft Certified Master

GilaMonster (4/28/2012)
Jeff Moden (4/27/2012)
And contrary to what I see many people leaning towards on these problems, it's not just Prometric's fault... where the heck was MSL for UAT and FAT...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 28, 2012 at 9:32 am

#1480852
RE: Demystifying the use of CASE in an ORDER BY statement

mtassin (4/27/2012)
Jeff Moden (4/26/2012)
It certainly takes a little longer to write but if you want really fast database code, then write database code in the database. If you want...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 28, 2012 at 9:31 am

#1480851
RE: boolean value

Sorry, wrong post.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 27, 2012 at 11:43 pm

#1480798
RE: Replacement for Cursors

Eugene Elutin (4/27/2012)
May be there are some folk here who will be able to establish an invisible connection to your mind and get the whole picture out of it, but...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 27, 2012 at 11:20 pm

#1480793
RE: Replacement for Cursors

vinu512 (4/27/2012)
Jeff Moden (4/27/2012)
vinu512 (4/26/2012)
But the requirement is that I do not need the Names as a "Set". I need them separately(one by one), so that I can use them...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 27, 2012 at 11:05 pm

#1480790
RE: need help to customise my T-SQL

dwain.c (4/27/2012)
Couldn't do it in a single statement though.
Heh... you say that as if there should be something to be ashamed about. "Set-based" doesn't mean "all in one query"....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 27, 2012 at 7:26 pm

#1480784
RE: Microsoft Certified Master

Uwe,
I share the sentiment. Good luck, especially with all that you've gone through in trying to take the exams.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 27, 2012 at 7:01 pm

#1480781
RE: Microsoft Certified Master

Steve Jones - SSC Editor (4/27/2012)
Jeff Moden (4/26/2012)
Robert Davis (4/25/2012)
I know that MSL is aware of this issue and I believe it has been escalated to Prometric
Wow! Seriously???...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 27, 2012 at 6:56 pm

#1480779
RE: Replacement for Cursors

vinu512 (4/26/2012)
But the requirement is that I do not need the Names as a "Set". I need them separately(one by one), so that I can use them further.
By definition, that's...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 27, 2012 at 6:31 am

#1480344
RE: Demystifying the use of CASE in an ORDER BY statement

ben.kimball (4/26/2012)
I can sorta barely make sense of that, but not a CF guy, so taking your word for how it communicates with the back end SQL server. 🙂
My statement...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 26, 2012 at 11:59 pm

#1480190

Viewing 15 posts - 30,271 through 30,285 (of 59,101 total)