Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,616 through 3,630 (of 59,087 total)

Reply To: Find Maximum Qty of fruits (regardless of fruit) which could be bought by $50

Jeff Moden wrote:
I may have something wrong with my understanding of the problem but, according to the values you've provided, there is no combination of fruits in case #1 where 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)

April 23, 2022 at 12:21 am

#4020798
Reply To: Find Maximum Qty of fruits (regardless of fruit) which could be bought by $50

I may have something wrong with my understanding of the problem but, according to the values you've provided, there is no combination of fruits in case #1 where you can...
--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)

April 23, 2022 at 12:13 am

#4020797
Reply To: How to get the first and last dates of all the months of the current year.

saliw768 wrote:
Hello,
I'm trying to get the first and last dates of all the months based on the current year.
1/1/2022
1/31/2022
2/1/2022
2/28/2022
3/1/2022
3/31/2022
Any help would be greatly appreciated. Thank you in advance!
You've got multiple...
--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)

April 22, 2022 at 11:51 pm

#4020796
Reply To: Scripting Makes Mistakes Easier Than Ever

It’s not “scripting” that makes mistakes easier... The real problem is "urgency of an issue". The same can happen when deploying code of any type. You covered what the real...
--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)

April 22, 2022 at 3:37 pm

#4020573
Reply To: Handle TSQL Session exections terminated by users

ktflash wrote:
Ahoi,
Theres a long running delete which is split into smaller batches.
how does one deal with the following situation.
The answer is likely going to be found in the code 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)

April 21, 2022 at 9:31 pm

#4020195
Reply To: Using T-SQL over PoSh

skeleton567 wrote:
Hate to admit I didn't even know what PoSh is...
PowerShell.
--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)

April 21, 2022 at 8:00 pm

#4020174
Reply To: How to add background color of row based to existing SP/query

Ah, my apologies. No. Have not gotten to this yet and I'm not sure about tonight because I have a presentation to give tonight. Thank you for the reminder 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)

April 21, 2022 at 5:59 pm

#4020125
Reply To: Fact Table Update (Design)

Niggles wrote:
Apologies for the confusion in relation to relaying my thoughts on the whole process, I think it's a bit tricky to vocalise. I think I'll implement it as 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)

April 20, 2022 at 9:37 pm

#4019578
Reply To: Fact Table Update (Design)

Niggles wrote:
What I'm trying to ascertain here is if it's feasible to make the whole model temporal (i.e. all Fact tables & Dimensions) so it can be rolled back 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)

April 20, 2022 at 7:10 pm

#4019512
Reply To: Fact Table Update (Design)

I agree that Temporal tables don't have an explicit marking for the action taken on a row for MS Temporal Tables. It's really easy to determine, though... (and you probably...
--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)

April 20, 2022 at 2:38 pm

#4019331
Reply To: How to prevent -5 Blocking Session

Johan Bijnens wrote:
fyi: Negative Blocking Session Ids
That's the same link that the Op provided in the original post on this thread. 😀
--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)

April 20, 2022 at 1:47 pm

#4019281
Reply To: Fact Table Update (Design)

Ok... based on your last post above, especially the part where you say there's a "requirement to make multiple submissions at various milestones during the month", here's what I think. ...
--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)

April 20, 2022 at 1:13 am

#4018898
Reply To: SQL DB Email sending,HTML body formatting from two tables

Awesome. Thank you for the feedback and welcome aboard!
--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)

April 19, 2022 at 2:49 pm

#4018668
Reply To: How to add background color of row based to existing SP/query

I'll try to work on this tonight after work. Thanks for the example.
--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)

April 19, 2022 at 2:45 pm

#4018664
Reply To: Scalar function string replacement

Jason A. Long wrote:
If you're using SQL Server 2017 or later, the TRANSLATE() function would be a better option.
I missed this. Considering what they did to the FORMAT function for performance, 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)

April 19, 2022 at 2:24 pm

#4018637

Viewing 15 posts - 3,616 through 3,630 (of 59,087 total)