Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,116 through 2,130 (of 59,067 total)

Reply To: ISNULL in case statement
ScottPletcher wrote:
ISNULL/COALESCE is not as clear as explicitly checking for NULL:
```
SELECT COL1,
CASE WHEN Table1.COL2 = 0 then 'ZERO'
WHEN Table1.COL2 = 1 OR Table1.Col2 IS NULL then 'ONE'
ELSE...
```
--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 11, 2023 at 2:28 am

#4136217
Reply To: Invoke a Tableau dataset refresh from a SQL Agent Job
I know almost nothing of Tableau, so just a couple of thought-provoking ideas.
1. Couldn't you have the Tableau Timer check to see if an "ItsDone.txt" file contains a certain file...
--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 11, 2023 at 2:18 am

#4136216
Reply To: Error using python in SQL2022: DLL load failed on import: pylink and px_call

Heh... Had to laugh...I was just thinking that "Revo-Scalepy" (revo-sca-lepy) might make a great name for a line of blenders and food processors. 😀 😀 😀
--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 11, 2023 at 2:13 am

#4136215
Reply To: average of percentage

sqlenthu 89358 wrote:
Jeff Moden wrote:
sqlenthu 89358 wrote:
Hi Steve, thanks but what you are providing here is calculating percentage. My ask is to get an average of 4 month percentage (or 5 or 6...
--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, 2023 at 6:03 pm

#4136045
Reply To: Step functions trigger rule

Looks like Frederico was ultimately correct.
--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, 2023 at 12:54 am

#4135725
Reply To: The Time Conversion

Eirikur Eiriksson wrote:
TRY_CAST can be useful for simplifying error handling as it returns NULL rather than raising an error. 😎
Agreed but I've also found that it makes people complacent 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)

January 9, 2023 at 4:49 pm

#4135565
Reply To: The Time Conversion

sknox wrote:
This is a very good reminder that data validation is not just limited to the straight format.
Yep... I totally get that but this is one of those places where...
--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, 2023 at 4:29 pm

#4135549
Reply To: Update CR LF in the string as empty

Saran wrote:
CR LF is breaking my data load into mysql, I have updated CR LF as space ' ' and load is working good.
To Frederico's point, it may be 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)

January 9, 2023 at 4:24 pm

#4135547
Reply To: Advice on how to move forward in my career

JasonO wrote:
As I myself are not sure if I still want to continue to be a DBA or move on to another field of work or even moving up 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 9, 2023 at 8:45 am

#4135337
Reply To: How much memory is allocated when you UNION ALL?

I guess my question would be.... Why not just try it and see? Then post the answer here and Google will have a place to land the next time someone...
--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, 2023 at 8:10 am

#4135332

Reply To: Update CR LF in the string as empty

Yes. The following will do the trick for LfCr, CrLf, Cr, and Lf... Just replace the table name and the column name with your actual table and column names.

--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, 2023 at 8:07 am

#4135331

Reply To: Generation of Auto Series based on logic

Just for convenience, here's the formula. Replace the "t.N" with the name of your IDENTITY column that starts at zero.

CONCAT('10.',CHAR(66+t.N/1000),RIGHT(CONCAT('00',t.N%1000),3))

EDIT: Forgot to add that it would be...

This reply was modified 3 years, 5 months ago by Jeff Moden.

--Jeff Moden

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, 2023 at 7:39 am

#4135321

Reply To: Generation of Auto Series based on logic

Yes. And, it's easy. Start an IDENTITY column at "0". Add a computed column with the formula from my previous query but replace the "t.N" in both places with the...

--Jeff Moden

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, 2023 at 7:36 am

#4135320