Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,946 through 33,960 (of 59,099 total)

RE: Are the posted questions getting worse?

jcrawf02 (5/11/2011)
Craig Farrell (5/10/2011)
Hey all, sorry I fell off the earth a bit, even when I had an article go up. Thanks for the applause those who posted, 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)

May 12, 2011 at 9:22 pm

#1324072
RE: Are the posted questions getting worse?

Stefan Krzywicki (5/12/2011)
Steve Jones - SSC Editor (5/12/2011)
So it's a snow day here, kids off from school. I've already fired up the tractor, been up and down the driveway twice...
--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)

May 12, 2011 at 9:10 pm

#1324071
RE: Are the posted questions getting worse?

Stefan Krzywicki (5/12/2011)
Just got a job req email for a .Net position. Some strange requirements though.
"Strong analytical skills as well as demons ratable code maintenance/bug-fix experience are required."
Is demon rating...
--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)

May 12, 2011 at 9:00 pm

#1324069
RE: Are the posted questions getting worse?

jcrawf02 (5/12/2011)
Jeff, http://www.sqlservercentral.com/Forums/Topic1107435-338-1.aspx#bm1108098
Very cool. Thank you for the referral and glad it helped. Well done all the way around.
--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)

May 12, 2011 at 8:56 pm

#1324068
RE: Get the First letter of each word within a string and returned a concatenated string

peterzeke (5/12/2011)
Question: I don't quite understand why a tally table that's built "on the fly" is used rather than referencing a prebuilt tally table. Is the performance quite different using...
--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)

May 12, 2011 at 8:53 pm

#1324066
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Just to keep everyone posted, I've submitted an update to the article including the tests on Nadrek's and Peter's functions. Since Peter's was the faster of the two, I've...
--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)

May 12, 2011 at 8:27 pm

#1324063
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Hmmmm... I thought that Access had a running total function built in. I might be getting it confused with SSRS.
--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)

May 12, 2011 at 7:57 pm

#1324060
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Would there be a way to use the running total function in Access to make a kind of ROW_NUMBER function?
--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)

May 12, 2011 at 7:09 pm

#1324049
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Nadrek (5/12/2011)
Jeff Moden (5/11/2011)
Sorry... I missed this... Maybe not in your country or language but that's not what's implied by such language in my country and the two statements have...
--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)

May 12, 2011 at 6:58 pm

#1324048
RE: Conditional Counting

opc.three (5/11/2011)
I think you want to use SUM with a CASE statement. Maybe something along these lines:
SELECT SUM(CASE WHEN B.TRANS_TYPE = '2' THEN 1
...
--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)

May 12, 2011 at 11:29 am

#1323855
RE: Conditional Counting

varunkum (5/11/2011)
In UNICA.SUBS table i have Account, TRANS_DATE, TRANS_TYPE, PROD_CODE and CODE columns.
SELECT count(B.TRANS_TYPE) STARTS, B.PROD_CODE pcode, B.CODE CScode
FROM UNICA.SUBS B
WHERE B.TRANS_DATE between...
--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)

May 12, 2011 at 7:47 am

#1323665
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Thanks, Mark. Looks good.
It's been a thousand years since I've even touched Access. Does it have any type of row numbering function available to 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)

May 12, 2011 at 7:26 am

#1323646
RE: Get the First letter of each word within a string and returned a concatenated string

peterzeke (5/11/2011)
Jeff Moden (5/10/2011)
Pete,
Based on the findings in the post above, will you ever have a condition where the first character isn't a letter?
Jeff -- the first character should just...
--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)

May 11, 2011 at 8:26 pm

#1323451
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

ethan.murray (5/11/2011)
Thanks to all the contributors to this article and its comments. To help some purists understand how Jeff's article is adding value: I work in a management consulting...
--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)

May 11, 2011 at 5:05 pm

#1323431
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Nadrek (4/12/2011)
Jeff Moden (4/12/2011)
"Do not use this for critical things" is an "advertisement"? Not where I come from. 😉
And, yes, I use it for "critical" things.
Anyway, sorry about...
--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)

May 11, 2011 at 5:04 pm

#1323430

Viewing 15 posts - 33,946 through 33,960 (of 59,099 total)