Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,226 through 6,240 (of 59,089 total)

Reply To: Count the Number of Weekend Days between Two Dates

Just to be sure, Jacob... I really like your solution (especially since I've tested the bejeezus out of it in the area of functionality) because of the integer math, lack...
--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 18, 2020 at 5:11 pm

#3798591
Reply To: using same name for cursors and temp tables on different stored procedures

To Frederico's good point, please see the following article for an introduction to "Tally Tables" (also known as "Numbers" tables). Keep in mind that it's only an introduction and do...
--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 18, 2020 at 4:58 pm

#3798590
Reply To: Count the Number of Weekend Days between Two Dates

SwePeso wrote:
I use Google...
https://weblogs.sqlteam.com/peterl/2009/07/12/how-to-calculate-the-number-of-weekdays-for-any-given/
That, however, doesn't count the number of weekend days as the OP requested. It wouldn't, however, provide much difficultly to the OP to realize that if 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)

October 17, 2020 at 7:35 pm

#3798406
Reply To: Count the Number of Weekend Days between Two Dates

Jacob Wilkins wrote:
Jeff,
Thanks for taking a look.
The problem is indeed one of the range (as Jeffrey also pointed out while I typed this up). The math trick won't work once negative...
--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 17, 2020 at 7:07 pm

#3798401
Reply To: Count the Number of Weekend Days between Two Dates

Eirikur Eiriksson wrote:
He he, look what the cat dragged in!
😎
More than two years on and it's still interesting? Feels like eating last week's take out pizza.
Heh... I've done that. It does...
--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 17, 2020 at 4:16 pm

#3798371
Reply To: Count the Number of Weekend Days between Two Dates

Jacob Wilkins wrote:
It's late in the day, and I'm below my quota of coffee (all too common these days, I really need to rekindle my coffee habit), but here's another, fairly...
--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 17, 2020 at 3:37 pm

#3798359
Reply To: Execution Plan

Ah... I just thought of something else it could be. Have the Developers check the connection strings for the apps. If it doesn't explicitly turn off MARS (multiple active result...
--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 17, 2020 at 1:49 am

#3798226
Reply To: processing a flat file without knowing the name

One simple way is to use xpDirtree to read the file names in the source directory and then use BULK INSERT or OPENROWSET with the ACE drivers (if you're trying...
--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 17, 2020 at 1:08 am

#3798225
Reply To: Help With a Dynamic Pivot Returning All Nulls

You really haven't given us anything to go on. Just listing a bunch of code that returns a NULL result set isn't much of a clue.
Have you tried printing 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 17, 2020 at 12:16 am

#3798212
Reply To: Import/export

Admingod wrote:
I am looking to export data from SQL 2019 to sql 2017. What if the tables have primary key and foreign key relationship how would be the export 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)

October 17, 2020 at 12:10 am

#3798210
Reply To: using same name for cursors and temp tables on different stored procedures

With the idea of teaching a person to fish, a temp table is still a table and you're trying to create one in each of the 3 procs. That's 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 16, 2020 at 11:47 pm

#3798209
Reply To: Un-queried tables

If the use of schemas gives one the heebee-jeebees, then a control table like yours or using prefixes on the table names would work just as well. I like your...
--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 16, 2020 at 4:30 am

#3797849
Reply To: Clustered Indexes on GUIDS, Complex chains of triggers and Heaps

david.edwards 76768 wrote:
Jeff Moden wrote:
Just went through all that code and lordy.
8<
Many thanks for taking the time to wade through that lot Jeff, and I hope your blood pressure didn't rise too...
--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 15, 2020 at 8:35 pm

#3797756
Reply To: Get list of databases from failed SQL Server instance

Steve Jones - SSC Editor wrote:
You inspired me. I'm going to write an article based on this, as some of these things are interesting from a DR standpoint.
The very first recommendation in such an...
--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 15, 2020 at 6:42 pm

#3797723
Reply To: Un-queried tables

We have a lot of such tables. I use the schema of a table to help and got everyone onboard with it.
If the table is supposed to have a really...
--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 15, 2020 at 6:23 pm

#3797715

Viewing 15 posts - 6,226 through 6,240 (of 59,089 total)