Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,431 through 11,445 (of 59,102 total)

RE: Count the Number of Weekend Days between Two Dates

My very first article on this site was about how to find work days (week days, really... no holidays involved). Figured I'd update from that a bit to solve this...
--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)

August 23, 2018 at 8:49 pm

#2003138
RE: Count the Number of Weekend Days between Two Dates

ScottPletcher - Thursday, August 23, 2018 4:24 PM
There's no need for any tally table nor recursion. A simple mathematical calc is...
--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)

August 23, 2018 at 7:28 pm

#2003137
RE: Count the Number of Weekend Days between Two Dates

dbeggs57 - Thursday, August 23, 2018 6:01 PM
Jeff:
Thank you for correcting my code. This gives me something more to think 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)

August 23, 2018 at 7:17 pm

#2003136
RE: Count the Number of Weekend Days between Two Dates

dbeggs57 - Thursday, August 23, 2018 2:12 PM
Adam, thank you for your example, it got me thinking. I didn't have the table you...
--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)

August 23, 2018 at 5:31 pm

#2003130
RE: Bullk insert in sql server..

Unless they've changed it recently, BULK INSERT and BCP are delimiter sensitive when it comes to counting rows rather than what humans perceive to be a line in a 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)

August 23, 2018 at 3:48 pm

#2003122
RE: PIVOT

TJ_T - Thursday, August 23, 2018 10:53 AM
I need help with SQL PIVOT
Example
SELECT Manufacturer, CarType
FROM Vehicles
Manufacture Cartype
Ford ...
--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)

August 23, 2018 at 3:40 pm

#2003121
RE: Convert Varchar field

bpmosullivan - Wednesday, August 22, 2018 7:35 PM
I have a Varchar field with units in inches 🙁 that i need to convert...
--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)

August 23, 2018 at 3:35 pm

#2003118
RE: Is it possible to retrieve name(s) of SSIS package(s) that have an Exec SQL task that executes a specific SP?

VoldemarG - Thursday, August 23, 2018 3:03 PM
True. but there are 1100 packages on 3 prod servers... 🙂
Heh... Phil wasn't suggesting 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)

August 23, 2018 at 3:29 pm

#2003117
RE: Count the Number of Weekend Days between Two Dates

carsten.saastamoinen - Thursday, August 23, 2018 9:54 AM
"Every bit helps avoid the "Death by 1,000 cuts" that so many systems experience. ...
--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)

August 23, 2018 at 11:02 am

#2003084
RE: Count the Number of Weekend Days between Two Dates

csj - Thursday, August 23, 2018 7:55 AM
But use of memory for the recursive solution is not a problem until someone uses 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)

August 23, 2018 at 8:11 am

#2003058
RE: Count the Number of Weekend Days between Two Dates

csj - Thursday, August 23, 2018 7:31 AM
One of the big problems when we are writing SELECT statement is, that there is...
--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)

August 23, 2018 at 7:48 am

#2003051
RE: File sizes in system tables

elea.grig - Thursday, August 23, 2018 6:48 AM
I am querying select * from sys.master_files in order to know the file sizes...
--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)

August 23, 2018 at 7:34 am

#2003047
RE: Sanity check

HappyGeek - Wednesday, August 22, 2018 11:59 AM
Even if you had a tried and proven method of managing file growth, would you...
--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)

August 23, 2018 at 7:30 am

#2003045
RE: Count the Number of Weekend Days between Two Dates

While I don't necessarily agree with the way things were done in the article, I have to tell you that I never agree with any form of recursion even 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)

August 23, 2018 at 7:10 am

#2003040
RE: Count the Number of Weekend Days between Two Dates

csj - Thursday, August 23, 2018 1:29 AM
Why do it in such a complex way. Use recursion, which also is faster 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)

August 23, 2018 at 6:50 am

#2003036

Viewing 15 posts - 11,431 through 11,445 (of 59,102 total)