Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,096 through 4,110 (of 59,067 total)

Reply To: My New Resolution

leonardo.ssantos79 wrote:
But the question was ONLY the year, and the year function (getdate()) doesn't do that?
The question was about how to find rows in a table based on the current...
--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, 2022 at 3:04 pm

#3971180
Reply To: Select and Distinct

I just noticed timers on the jpg's with just a couple of hours left. If it were me, I'd go with interpreting the word "respective" as meaning the professor 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)

January 6, 2022 at 2:32 am

#3970380
Reply To: Start Sql server agent job after a trigger

Johan Bijnens wrote:
Keep in mind it may take SQLAgent up to 20 seconds to respond.
I'm the same way until I have two 12 ouncers of coffee under my belt. 😀
--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, 2022 at 2:07 am

#3970376
Reply To: Select and Distinct
Sorry... I made a mistake and had to rewrite this post.
Please see the post above. The word "respective" needs to be clarified because there are two possible solutions depending on...
- This reply was modified 4 years, 5 months ago by Jeff Moden. Reason: Rewrote the post because of an ambiguity in the word "respective"
--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, 2022 at 1:44 am

#3970371
Reply To: Select and Distinct
I did a misread on the requirements because there are actually two possible answers according to the posted requirements and so had to rewrite this post.
Still, there is no need...
- This reply was modified 4 years, 5 months ago by Jeff Moden. Reason: Rewrote the post because of an ambiguity in the word "respective"
--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, 2022 at 1:31 am

#3970364
Reply To: clustered index usage

Snargables wrote:
So just to clarify. if i have a clustered index on say contactid and invoiceid however none of the updates are on those columns then there wouldn't be 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)

January 6, 2022 at 1:13 am

#3970362
Reply To: Complicated Insert SQL with Calculations
THE PREVIOUS CODE I HAD POSTED PRODUCED THE WRONG VALUES FOR THE 1st ROW OF FEDERALTAX OF THE "XX" ROWS. I HAD COPIED YOUR FORMULA WITHOUT REALIZING THERE WAS A...
- This reply was modified 4 years, 5 months ago by Jeff Moden. Reason: Repair a formula in the code
--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, 2022 at 12:09 am

#3970353
Reply To: issue max value for records inserted all take number 4 i need it 4,5,6,7 ?

Building your own sequential numbers is a sure fire way to generate duplicates by accident. Even Des Norton notes that for his code.
Please explain why you're trying to avoid 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)

January 5, 2022 at 10:27 pm

#3970326
Reply To: Trying to return strings starting with 'dbo.'

JaybeeSQL wrote:
Neither set of code is coming up with a meaningful result set, not sure where the disconnect here is, but I'll try again:
If a row contains: koagvakjnonsenseajg4648.dbo.RandomTableForSSChahfhaijfhfhf5664646
I want to...
--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, 2022 at 10:16 pm

#3970325
Reply To: How to get the permission creation and modification date

Gibbs wrote:
You can modify the date created by copying a file. The file's created date becomes the modified date and the current date when the file is copied becomes 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)

January 4, 2022 at 7:02 pm

#3969864
Reply To: Start Sql server agent job after a trigger

rafamaniac wrote:
ok thank you, will see what the service broker can do.
K... just remember that's not my first choice. For me personally, it wouldn't be a choice. Like I said,...
--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 4, 2022 at 6:56 pm

#3969862
Reply To: Missing Indexes

Hawkins_IT wrote:
Sorry my post is confusing. I wasn't really sure how elaborate on it. Yes, we are having performance issues and it mainly looks like disk IO latency. We 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)

January 4, 2022 at 6:52 pm

#3969861
Reply To: Multiple Date rows into One single Date row(date range)

Thanks. I definitely missed your 301 comments below the 2nd spreadsheet you posted.
You say to only worry about the contiguous dates but neither the Green or the Purple sections 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)

January 4, 2022 at 6:38 pm

#3969858
Reply To: Start Sql server agent job after a trigger

rafamaniac wrote:
Is it possible to start Sql server agent job after a trigger? what i want to do is after a certain table updates a certain column, then it runs...
--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 4, 2022 at 3:50 am

#3969534
Reply To: Get Data from Internet Directly into SQL Server

That's awesome, Frederico! Thanks for posting that.
It would appear, though, that you actually have to program for the table structure. Is there anything like the getting data from the Web...
--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 4, 2022 at 1:29 am

#3969511

Viewing 15 posts - 4,096 through 4,110 (of 59,067 total)