Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,871 through 3,885 (of 59,098 total)

Reply To: Extract date from a text field

ashatimjohn wrote:
I'm trying to extract date from a text field. I'm using PADINDEX to do this. My results are very inconsistent. Is there anyway I can do this through SQL. ...
--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, 2022 at 6:25 pm

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

There are several people that I've recently decided are earning a living based on the kindness of strangers that I will no longer help especially since they've been doing 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, 2022 at 5:56 pm

#3990631
Reply To: How to get Two averages when the Number is defined as nvarchar ?

ScottPletcher wrote:
Jeff Moden wrote:
(Although the product ID is correctly an NVARCHAR and I'm hoping the NVARCHAR isn't actually a part of the column name 🙁 )
Hmm, I think it's a waste...
--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, 2022 at 5:48 pm

#3990630
Reply To: Another look at table variables

I've lost the old link that I had about this and, if I still had it, it probably wouldn't work anymore anyway. A lot of people don't know that Temp...
--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, 2022 at 5:29 pm

#3990619
Reply To: List Dates between Start and End Date

Phil Parkin wrote:
Jeff Moden wrote:
@Ohil and @steve-2... thank you both for the honorable mention.
I've been called many things, but it's a first for Ohil 🙂
The "O" is apparently because "OH! More coffee,...
--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, 2022 at 4:57 pm

#3990604
Reply To: List Dates between Start and End Date

@Ohil and @steve-2... thank you both for the honorable mention.
--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, 2022 at 4:23 pm

#3990556
Reply To: List Dates between Start and End Date

Jonathan AC Roberts wrote:
Install the table valued function in this script: https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function
I'll say it again... that's a killer general purpose function with a lot of uses. Thanks for publishing that, Jonathan.

--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, 2022 at 4:20 pm

#3990552
Reply To: view definition hide from SA user

rachit.dba wrote:
Can I hide view definition of others users's procedures from SA user. I want to hide business logic.
The only way to do this is to deliver you code on...
--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, 2022 at 4:15 pm

#3990549
Reply To: How to get Two averages when the Number is defined as nvarchar ?
protocoder wrote:
Hi experts,
Sorry for not getting you a table or data at this moment but I will if I need to get help tomorrow
How do I get
1. Average of Cost
2....
--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, 2022 at 3:59 pm

#3990522
Reply To: How to get Two averages when the Number is defined as nvarchar ?

Johan Bijnens wrote:
and kick the designer in a place where it hurts ...

That would NOT be in the area above the shoulders... they're obviously feeling no pain there. 😀 (Although 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, 2022 at 3:55 pm

#3990514
Reply To: Less is More

I really enjoyed this article and linked items. I remember way back when (more than 3 decades ago) I would manually check the waveform coming form the UPS, doing battery...
--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, 2022 at 3:41 pm

#3990491
Reply To: Running total with reset condition

Steve Jones - SSC Editor wrote:
Please mark Jeff's answer as correct, if you wouldn't mind.
BWAAA-HAAA! Well that didn't work. 😀
--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, 2022 at 2:07 am

#3989964
Reply To: Proxy accounts failing to authenticate intermittently

This is a pretty good example of why companies will always need a DBA. 😀
--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 24, 2022 at 11:07 pm

#3988575
Reply To: Help with proper indexes

If the IDENTITY column is used properly and not just as a row number, then you DO need to consider the joins because they will be mostly by IDENTITY. 😉

--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 24, 2022 at 11:05 pm

#3988574
Reply To: sql tutorial for beginners

sengeet86 wrote:
good for beginners.
http://www.sqlcourse.com/index.html
http://www.w3schools.com/sql/default.asp
Even though the post above is a decade old now, it's still a great recommendation. I can't speak to the first link with any knowledge because 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)

February 24, 2022 at 6:58 pm

#3988476

Viewing 15 posts - 3,871 through 3,885 (of 59,098 total)