Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,531 through 43,545 (of 59,097 total)

RE: Forums on your Resume/CV

Steve Jones - Editor (6/8/2009)
In my presentation this past weekend in Florida, someone asked if I thought recruiters or HR people would look over forum postings when considering a candidate...
--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)

June 8, 2009 at 11:14 pm

#1006431
RE: COUNT function within CTE

mmunson (6/8/2009)
Here is an example of my result set:
Service Employee Group | Serv Order ID | Conf ID
T - CSAEZR7 Region 7 - Field30000000089000000933
T - CSAEZR7 Region 7 - Field30000000089000002367
T...
--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)

June 8, 2009 at 11:06 pm

#1006426
RE: How to query data on weekly basis

ganeshlohani,
Part of the reason that you only got suggestions instead of code is because you didn't post your problem correctly so that people had some readily consumable data to test...
--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)

June 8, 2009 at 10:58 pm

#1006425
RE: How to query data on weekly basis

{edit} Thanks to David Jackson. I was missing the WHERE clause in the final dynamic SQL and the caused the totals at the right of the output to...
--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)

June 8, 2009 at 10:55 pm

#1006423
RE: Performance Issues with Dynamic SQL

Reddy B (6/8/2009)
Thanks a lot, Barry. I really appreciate all of your help. You blog pointed me to the right direction.
Great Job.
-B
Enquiring minds want to know... which direction did...
--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)

June 8, 2009 at 9:39 pm

#1006402
RE: sql text

Yep... I agree... profiler. The link that Wayne points to contains just about everything you'll need to know.
Of course, you could always just ask the user what they're running....
--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)

June 8, 2009 at 9:36 pm

#1006401
RE: convert row to column

Kokfai,
You'll find that most folks like to test their answers before posting them. Instead of posting the data as a graphic, please see the link in my signature for...
--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)

June 8, 2009 at 9:31 pm

#1006400
RE: Dates Between From date and To Date

pramod_yg (6/8/2009)
Thanks a lot Guys... it was really helpful.
Thank YOU for the feedback. 🙂
--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)

June 8, 2009 at 4:35 pm

#1006345
RE: Are the posted questions getting worse?

jcrawf02 (6/8/2009)
Florian Reischl (6/8/2009)
tosscrosby (6/8/2009)
Florian Reischl (6/8/2009)
Oups!
A typo in my "Smurf"...
I didn't know if you call him "Daddy" or "Papa". Just thought "Daddy" is more common in US.
Thanks Jeff!
Only in...
--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)

June 8, 2009 at 2:55 pm

#1006317
RE: buld a rule with Numeric chars only

Lowell (6/8/2009)
thanks everyone; RBarryYoung made the light go on when he said "escape" the second minus sign.
Lynn's example works, as well as using a different rule, which in turn...
--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)

June 8, 2009 at 12:55 pm

#1006268
RE: Are the posted questions getting worse?

GilaMonster (6/8/2009)
Lynn Pettis (6/8/2009)
GilaMonster (6/8/2009)
Hey Barry. How about some basic Computer Science theory to start the day?
http://www.sqlservercentral.com/Forums/Topic730611-8-1.aspx
Oh, great, our "PhD Candidate". Could have warned us on that one, Gail.
And...
--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)

June 8, 2009 at 12:32 pm

#1006255
RE: Are the posted questions getting worse?

tosscrosby (6/8/2009)
Florian Reischl (6/8/2009)
Sometimes I'm feelin' like "Daddy Snarf" on this page...
Edit: Do you understand German?
I don't understand German. WTF does that mean?...goggle didn't help much! :w00t:
Bwaa-Haaa!!!! I think...
--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)

June 8, 2009 at 12:28 pm

#1006249
RE: "Greek" data in my SQL table

Heh... just replace the names with NEWID().
--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)

June 8, 2009 at 12:10 pm

#1006229
RE: CTE question

Greg,
One of the supposed advantages listed above for a CTE is if you have to reference the query it contains more than once. Let me say how dangerous that...
--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)

June 8, 2009 at 11:55 am

#1006217
RE: CTE question

Ramesh (5/29/2009)
The 3rd biggest thing is that you can write recursive queries using CTE.
... and kill yourself with hidden RBAR that rivals that of a cursor. 😉
--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)

June 8, 2009 at 11:53 am

#1006213

Viewing 15 posts - 43,531 through 43,545 (of 59,097 total)