Jeff Moden

Forum Replies Created

Viewing 15 posts - 241 through 255 (of 59,099 total)

Reply To: Send results of a SQL query in Outlook email body

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Lord Slaagh wrote:
Hi SSC team,
I wanted to leave the answer here just in case anyone else needs it. This works. Only caveat is that you need to use dts.vaiables...
--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)

January 10, 2025 at 2:34 am

#4513012
Reply To: The Lesser Used Functions

I use IIF a whole lot to replace the longer CASE expression in CROSSTABs. It just makes for shorter code when there are only Yes/No conditions.
I have used some of...
--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)

January 10, 2025 at 2:26 am

#4513011
Reply To: Count of Total Appointments within 30 days of each Appointment Date

First of all, please stop posting graphics for the test data. See the article at the first link in my signature line below for why and one method for producing...
--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)

January 9, 2025 at 5:42 pm

#4512787
Reply To: Count of Total Appointments within 30 days of each Appointment Date

Just to be sure... you're in an SQL Server 7/2000 forum... which release of SQL Server are you actually using?
And, yeah... It's really important because there's a whole lot missing...
--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)

January 9, 2025 at 5:30 pm

#4512784
Reply To: Send results of a SQL query in Outlook email body

Lord Slaagh wrote:
Hi SSC team,
I wanted to leave the answer here just in case anyone else needs it. This works. Only caveat is that you need to use dts.vaiables instead of...
--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)

January 9, 2025 at 4:20 pm

#4512741
Reply To: why no suggested indexes in estimated exec plan?

stan wrote:
thx jeff. eventually i did do the divide and conquer thing. it took the query down from 6 minutes to 19 seconds. i turned it over in that state...
--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)

January 9, 2025 at 1:12 am

#4512331
Reply To: why no suggested indexes in estimated exec plan?

Shifting gears to the dark side, it may be that the query was written in such a fashion that the optimizer just can't figure out if an index would help...
--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)

January 8, 2025 at 4:17 pm

#4512133
Reply To: create multiple output files based on query

Ok... so you don't need the xp_CmdShell example then.
--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)

January 6, 2025 at 4:06 pm

#4510922
Reply To: create multiple output files based on query

Bruin wrote:
Thanks for response, would you be able to mock up an example of how that can be achieve? I just need an easy way to crank out files based...
--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)

January 5, 2025 at 5:49 pm

#4510447
Reply To: Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing

cyrusbaratt wrote:
Good work Jeff.
Not so good... I somehow missed what the OP had in the first post, which is...
Dell PE T430
2 - Xeon E5-2630 2.4GHz
64GB RAM
PERC H730 Controller 1GB cache
2...
--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)

January 3, 2025 at 4:53 am

#4509265
Reply To: printing complete path

mtz676 wrote:
Thank you Jeff. Looks like my google search was not good enough. Thanks again.That helped.

Heh... I just get lucky that wway.
--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)

January 3, 2025 at 4:49 am

#4509264
Reply To: Happy New Year 2025

skeleton567 wrote:
Yes, Jeff, those were the days of news instead of propaganda. Thanks for the memories.
There were some fond memories made back then.
--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)

January 3, 2025 at 4:38 am

#4509262
Reply To: Big Data or Small Data

"Bumping" my latest reply because of the forum's "Page 2" problem.
--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)

January 3, 2025 at 4:31 am

#4509253
Reply To: Big Data or Small Data

Alex Stuart wrote:
Jeff Moden wrote:
And, yeah... that was one of the times where they said "It didn't run" when they tested it because it ran so comparatively fast.
Hah - I've had...
--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)

January 3, 2025 at 4:30 am

#4509250
Reply To: create multiple output files based on query

Bruin wrote:
Was there an issue with creating solution locally before deploy?
No... it's what happens when you deploy. The C: drive on the server should be avoided for this type of...
--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)

January 3, 2025 at 4:22 am

#4509247

Viewing 15 posts - 241 through 255 (of 59,099 total)