Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,831 through 4,845 (of 59,089 total)

Reply To: Are the posted questions getting worse?

Jeffrey Williams wrote:
I have found that just putting that together will often lead to a solution or helps identify the actual issue.
Heh... PREACH IT BROTHER! 😀
--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)

August 17, 2021 at 5:46 pm

#3920880
Reply To: Create a delta from downloaded info

Bruin wrote:
Answering Post by Jeff
"Two tables (one of existing data, one for new data) would be great."
Are you absolutely sure that you want to include the invoice date and 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)

August 17, 2021 at 4:06 pm

#3920842
Reply To: YTD Date calculation
Phil Parkin wrote:
DECLARE @FRDate DATE = '20210228';
DECLARE @newFRDate DATE = DATEFROMPARTS(YEAR(@FRDate) - 1, 4, 1);

SELECT @FRDate
,@newFRDate;
+1000
--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)
August 17, 2021 at 3:49 pm

#3920828
Reply To: Function for converting hh:mm:ss time to decimal equivalent

First of all, the function you wrote is converting the final output to DECIMAL(10,2) because that's exactly what you told it to do in the RETURN clause of the function.
Second,...
--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)

August 17, 2021 at 3:04 pm

#3920819
Reply To: SP causing blocking

Grant Fritchey wrote:
... maybe. Testing is your buddy in these circumstances.
Preach it Brother! One good test result is worth a thousand expert opinions.

--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)

August 17, 2021 at 12:21 pm

#3920729
Reply To: SP causing blocking

John Deupree wrote:
I have a simple proc that I suspect is causing intermittent blocking. It takes a customer ID (int) as a param and returns an output param FeatureFlag (bit) indicating...
--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)

August 17, 2021 at 12:19 pm

#3920728
Reply To: convert time for daylight saving ..UTC to EST

I've attached 3 functions for this that I needed to build for a project at the end of July. They're fully documented and they include test code for your QA/UAT...
Attachments:
You must be logged in to view attached files.
--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)

August 17, 2021 at 4:30 am

#3920596
Reply To: The Slow Upgrade of SQL Server Versions

Brent Ozar wrote:
Somebody wrote:
I guess I would be interested in knowing HOW the numbers of which versions running SQL Server were determined.
Not enough to actually click on the links in Steve's...
--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)

August 17, 2021 at 2:26 am

#3920572
Reply To: Cursor replacement suggestions

I'm with Frederico on this... I wouldn't try to salvage the old code. The only thing I'd take from the old code is what the overall goals for ALL 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)

August 17, 2021 at 2:19 am

#3920570
Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

ZZartin wrote:
At least when you're dealing with XML or JSON the average end users is too intimidated by the format(and usually lacks the tools anyways) to directly mess and generate...
--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)

August 16, 2021 at 5:05 pm

#3920453
Reply To: I am submitting an article. How can I insert IMAGE (screenshot) between text?

VoldemarG wrote:
Well ,this is something I wanted to run by you, too.
Steve Jones said that if I am going to submit this and more articles, -- I intend from now...
--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)

August 16, 2021 at 2:35 pm

#3920393
Reply To: Are the posted questions getting worse?

Adi Cohn wrote:
If someone writes a blog but doesn't let us comment on it, I will not hold it against him.
Adi
I will and do... especially when they post stuff that's just...
--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)

August 16, 2021 at 2:28 pm

#3920381
Reply To: Cursor replacement suggestions

The code is RBAR and super-logging on steroids. It calls a proc to write to the log at virtually every point and it's also running a string splitter for every...
--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)

August 16, 2021 at 2:08 pm

#3920376
Reply To: I am submitting an article. How can I insert IMAGE (screenshot) between text?

Ummm... what's with the name change?
--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)

August 15, 2021 at 6:19 pm

#3920152
Reply To: Create a delta from downloaded info

Jeffrey Williams wrote:
Jeff Moden wrote:
Not confusing for me. You have existing data and you have new data. He want's a way to compare the data that changed.
I do absolutely agree that he...
--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)

August 15, 2021 at 6:15 pm

#3920151

Viewing 15 posts - 4,831 through 4,845 (of 59,089 total)

Jeff Moden

Forum Replies Created

Attachments: