Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,721 through 3,735 (of 59,067 total)

Reply To: SQL Select only business hours data

ScottPletcher wrote:
Since you're only checking for an hour range, you can use BETWEEN. It's just as accurate and easier to code and read.
I agree that it's real tempting to use...
--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)

March 25, 2022 at 7:28 pm

#4006072
Reply To: get file name during loop and insert into Table

I have to ask... why are you trying to use PowerShell to do this? And you have the comment "# Loop through all tables and export a CSV of 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)

March 25, 2022 at 6:59 pm

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

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
Shifting gears a bit... the following message started showing up on my machine some time ago (seems like at least a week) on every post thread and ONLY...
--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)

March 25, 2022 at 4:30 pm

#4006013
Reply To: SQL Select only business hours data

yogi123 wrote:
below is to get business hours data
SELECT * FROM #TEMP WHERE CAST(LOADDATE AS TIME) BETWEEN '9:00:00' AND '17:59:59'
Thanks for your help
My recommendation is to get out of the habit...
--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)

March 25, 2022 at 4:25 pm

#4006008
Reply To: Permissions for Extended Events

To be sure, my laugh wasn't about your bit of misfortune. I was laughing because it appears to be yet another limitation of Azure. 😀
--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)

March 25, 2022 at 4:02 pm

#4006004
Reply To: Error - A call to 'LogonUserW' failed with error code: '1909'

It sounds like you have to rebuild the "proxy" account to make it work.
And using xp_CmdShell isn't a "terrible security practice". Giving non-DBA users the privs to run it directly...
--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)

March 25, 2022 at 2:02 pm

#4005939
Reply To: Permissions for Extended Events

BWAAA-HAAA-HAAA!!! (Sorry... couldn't help the laugh).
--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)

March 25, 2022 at 1:55 pm

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

Congratulations on the retirement. I've just about given up on SO. Discussions are discouraged... unless you happen to be a moderator. 🙁

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

March 25, 2022 at 1:46 pm

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

Shifting gears a bit... the following message started showing up on my machine some time ago (seems like at least a week) on every post thread and ONLY for this...
--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)

March 25, 2022 at 10:26 am

#4005873
Reply To: some rows go missing once in a while when querying for a batch

This all seems like it''s "just" a process timing issue and you haven't figured out the actual cause, yet. Is the process the creates the row actually finishing on time...
--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)

March 25, 2022 at 10:19 am

#4005869
Reply To: SQL Select only business hours data
yogi123 wrote:
Hi there,
I have task to select only data falls within business hours, meaning 9 am to 5 pm
```
CREATE TABLE #TEMP
(ID INT, LOADDATE DATETIME)

INSERT INTO #TEMP
SELECT 1,'2022-03-24...
```
--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)
March 25, 2022 at 2:14 am

#4005730
Reply To: Multiple data types in column

Just store everything as FLOAT. Integers are exact when converted to Floats so long is you don't violate the precision. Better yet, change both to be Decimal(38,15).
Then ask yourself if...
--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)

March 25, 2022 at 1:59 am

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

Steve Jones - SSC Editor wrote:
SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not catching more than 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)

March 25, 2022 at 1:35 am

#4005728
Reply To: Create a Free Azure Account

"Give 'em the razor; sell 'em the blades"
--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)

March 25, 2022 at 12:54 am

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

Thank all of you folks for the congrats and the well wishes. I'm just one person, though. This site wouldn't be worth a hill of beans without the rest of...
--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)

March 25, 2022 at 12:18 am

#4005707

Viewing 15 posts - 3,721 through 3,735 (of 59,067 total)