Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,856 through 3,870 (of 59,087 total)

Reply To: Extract date from a text field

Since there's no sample data, if the date is the only thing in the string, find the first occurrence of a digit and the last occurrence of a digit and...
--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 9:50 pm

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

At least they live up to the name of this thread. 😀
--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 9:45 pm

#3990738
Reply To: units divided by quantity and order by date

Shree23 wrote:
how to give logic for it. I am newbie
Heh... no you're not. According to the date of your first post, you've been working with SQL for nearly 2 years. ...
--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 9:30 pm

#3990731
Reply To: Remove values between single quotes.

The STRING_AGG() function, available in SQL Server 2017 and up, makes this a pretty easy task along with a very useful tool that originates from this very site. You could...
--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 7:50 pm

#3990680
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

Viewing 15 posts - 3,856 through 3,870 (of 59,087 total)