Jeff Moden

Forum Replies Created

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

RE: Random problems

Steve... I'm not sure what's happened, but this article is all but unreadable. Might look fine from Firefox, but IE8 is having a heck of a time with it.
--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 9, 2009 at 12:06 am

#1006452
RE: How to query data on weekly basis

Paul M. Corley (6/8/2009)
Also remember that a true fiscal year does not start on the same day every year.
Heh... "it depends".
--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 9, 2009 at 12:01 am

#1006451
RE: CTE question

Eralper (6/8/2009)
Hi Lynn,
Thanks for your warning 🙂
My main consideration at that function is not the performance in fact.
I just wanted to see if Recursive CTE can manage splitting string values.
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 11:56 pm

#1006448
RE: convert row to column

kokfai.lai (6/8/2009)
Hi Jeff,
Sorry for my stupidity for not reading the rules and regulation 1st b4 posting. I'll take a look at it when i have time. As you can see...
--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:23 pm

#1006433
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

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