Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,736 through 9,750 (of 59,091 total)

RE: Week of 1st day of Year

omelo - Monday, March 4, 2019 10:44 AM
Jeff Moden - Monday, March 4, 2019 10:37 AM
--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 4, 2019 at 10:47 am

#2023463
RE: Week of 1st day of Year

The following formula will do it for you.
(DATEPART(dy,DATEADD(dd,-53684,DATEDIFF(dd,-53684,@SomeDate)/7*7+6))-1)/7+1
1. It finds the first Sunday on or previous to the given date (-53684 is...
--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 4, 2019 at 10:37 am

#2023461
RE: Are the posted questions getting worse?

Beatrix Kiddo - Monday, March 4, 2019 5:03 AM
Sorry for your loss, Jeff. What a tough time many people are having right...
--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 4, 2019 at 6:59 am

#2023428
RE: get failed job per hour

It's pretty simple to find such overlapping ranges. Have a gander at the following link to learn how... just change the point of reference from months to hours.
http://www.sqlservercentral.com/articles/T-SQL/105968/
--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 4, 2019 at 6:01 am

#2023422
RE: Week of 1st day of Year

omelo - Saturday, March 2, 2019 9:10 AM
Hi, This post is old but it is related to the question I have.
I'm using ...
--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 4, 2019 at 5:58 am

#2023421
RE: Compare Two Row in the table and find what columns are changed based on idno and date

I have to admit to being strongly confused because your test data doesn't match your desired output.
For example, here's your desired output... I've pointed to two rows for...
--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 2, 2019 at 8:20 am

#2023374
RE: DBA left and they shut off his AD account

DataAnalyst011 - Friday, March 1, 2019 11:29 AM
You all are a life-saver. Thank you so much for all the advice. I've switch...
--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 1, 2019 at 5:15 pm

#2023360
RE: DBA left and they shut off his AD account

DataAnalyst011 - Thursday, February 28, 2019 1:51 PM
Our DBA left and they shut off his account. Of course, things started failing all...
--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 1, 2019 at 10:30 am

#2023314
RE: Are the posted questions getting worse?

Jack Corbett - Thursday, February 28, 2019 1:53 PM
Jeff Moden - Monday, February 25, 2019...
--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 1, 2019 at 8:01 am

#2023296
RE: Last DB Usage

DBA_007 - Thursday, February 28, 2019 5:46 AM
How to check DB last used or how to remove orphaned databases based on 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)

February 28, 2019 at 7:43 am

#2023203
RE: List edition and version of all SQL Server machines over the Network ...

I am by no means a Windows Ninja but it seems to me that the Domain Controller would be aware of all machines on the network. Perhaps interrogating the Domain...
--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)

February 28, 2019 at 7:33 am

#2023199
RE: How to determine what percent of a varchar column is a valid numeric?

allan.ford17 - Wednesday, February 27, 2019 3:11 PM
Lots of excellent advice and answers .. thank you all ..
Appreciate warnings from Jeff 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)

February 27, 2019 at 4:25 pm

#2023144
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, February 27, 2019 4:31 AM
I'm sorry for your loss, Jeff. You, your brother, and his wife have my...
--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)

February 27, 2019 at 1:44 pm

#2023134
RE: Are the posted questions getting worse?

David Burrows - Wednesday, February 27, 2019 9:03 AM
Jeff Moden - Monday, February 25, 2019 12:16 PM
--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)

February 27, 2019 at 1:43 pm

#2023133
RE: Are the posted questions getting worse?

TomThomson - Wednesday, February 27, 2019 9:12 AM
Jeff Moden - Monday, February 25, 2019 12:16 PM
--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)

February 27, 2019 at 1:40 pm

#2023132

Viewing 15 posts - 9,736 through 9,750 (of 59,091 total)