Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,996 through 14,010 (of 59,095 total)

RE: Help with basic stored proc, two part name giving me grief.

chennam9 - Sunday, October 22, 2017 3:16 PM
Duran - Thursday, October 19, 2017 11:20 PM
--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)

October 22, 2017 at 5:48 pm

#1964716
RE: Trying to speed up this 'GetWorkingDays' function.

jcelko212 32090 - Friday, October 20, 2017 10:28 AM
Easter alone requires too much math
Not so much true for quite awhile. Peter "PESO"...
--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)

October 22, 2017 at 4:07 pm

#1964713
RE: Please let me know what is wrong with my code.

jcelko212 32090 - Sunday, October 22, 2017 1:18 PM
Why do you assume that he's always going to be on only one...
--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)

October 22, 2017 at 2:55 pm

#1964711
RE: Trying to speed up this 'GetWorkingDays' function.

Here's my shot at this problem. Just to make life easy, I'll keep all the code together for this post. The code is attached as .txt files, which is 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)

October 22, 2017 at 11:44 am

#1964706
RE: Trying to speed up this 'GetWorkingDays' function.

You need to use Gail's dynamic "Catch All Query" method on that one.
--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)

October 21, 2017 at 8:28 pm

#1964682
RE: Trying to speed up this 'GetWorkingDays' function.

Jason A. Long - Saturday, October 21, 2017 4:55 PM
At this point I'm more disappointed with myself than I am any...
--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)

October 21, 2017 at 7:03 pm

#1964680
RE: SQL versus program

Here's one that caught my eye recently although it's already 4 years old. The thing that caught my eye was they were measure watts per transaction and translating that 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)

October 21, 2017 at 6:26 pm

#1964677
RE: SQL versus program

patrickmcginnis59 10839 - Friday, October 20, 2017 12:12 PM
Shifting gears, people will site things like the fact that EBAY uses no stored...
--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)

October 21, 2017 at 6:06 pm

#1964676
RE: Help with basic stored proc, two part name giving me grief.

DesNorton - Friday, October 20, 2017 12:28 AM
Duran - Thursday, October 19, 2017 11:20 PM
--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)

October 21, 2017 at 4:34 pm

#1964672
RE: parsing variable into @query using sp_send_dbmail

Ed Wagner - Saturday, October 21, 2017 2:05 PM
As far as I know, you aren't going to generate a native Excel file...
--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)

October 21, 2017 at 4:31 pm

#1964671
RE: Please let me know what is wrong with my code.

jcelko212 32090 - Saturday, October 21, 2017 10:01 AM
Lynn Pettis - Friday, October 20, 2017 6:15 PM
--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)

October 21, 2017 at 4:13 pm

#1964670
RE: exception data in DB

cavepoubelle - Saturday, October 21, 2017 9:21 AM
thanks Sue, this error appears when launching an application that connects to 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)

October 21, 2017 at 4:09 pm

#1964669
RE: using cross apply to find different values trough xml files eficiency

Eirikur Eiriksson - Saturday, October 21, 2017 3:13 AM
This is a very inefficient way of querying the XML, can you post 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)

October 21, 2017 at 4:00 pm

#1964668
RE: Trying to speed up this 'GetWorkingDays' function.

Jason A. Long - Saturday, October 21, 2017 2:07 AM
Well... I really am a big dumb animal... I forgot to unplug the...
--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)

October 21, 2017 at 3:58 pm

#1964667
RE: Trying to speed up this 'GetWorkingDays' function.

Jason A. Long - Friday, October 20, 2017 11:27 PM
Jeff Moden - Friday, October 20, 2017 7:47...
--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)

October 21, 2017 at 3:56 pm

#1964666

Viewing 15 posts - 13,996 through 14,010 (of 59,095 total)