Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,586 through 3,600 (of 59,067 total)

Reply To: Handle TSQL Session exections terminated by users

Thanks. That was awesome. Told me a lot.
Random GUIDs are GOOD... But not like THAT!
First and as a bit of a sidebar, you good folks have done yourselves a pretty...
--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 7:22 pm

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

pietlinden wrote:
Maybe do the P*Q for the lowest priced fruits, sort that way, then do a running total. Filter for running total less than your threshold?
Spot on early suggestion, Piet!
--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 3:00 am

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

Jonathan AC Roberts wrote:
Thanks Jeff, well spotted, I totally missed it.
The first time I looked at it, SO DID I. 😀
Again, nice use of the "Relational Multiplication" method! I'm still thinking 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)

April 23, 2022 at 2:59 am

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

Jonathan AC Roberts solved this problem very nicely using the fnTally() function to due the "Relational Multiplication of Rows". If we tweak his good code just a little bit, 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 23, 2022 at 2:33 am

#4020836
Reply To: Find Maximum Qty of fruits (regardless of fruit) which could be bought by $50
Jonathan AC Roberts wrote:
```
;with cte as
(
    select sum(t.price) over (order by t.price asc, v.N) RunningTotal, * 
      from #TEMP1 t
 ...
```
--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:51 am

#4020802
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

Viewing 15 posts - 3,586 through 3,600 (of 59,067 total)