Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,801 through 4,815 (of 59,089 total)

Reply To: How to split string and separate the data with numbers and text

Ok. First, I cleaned up the code that provides the test table and data generation so it's easier to read/verify. I also changed it from a table variable to a...
--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)

August 20, 2021 at 6:26 pm

#3922220
Reply To: How to split string and separate the data with numbers and text

Missed David's post, which he posted while I was still writing.
--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)

August 20, 2021 at 5:01 pm

#3922206
Reply To: How to split string and separate the data with numbers and text

sqldevlearn wrote:
Here is the fiddle http://sqlfiddle.com/#!18/334d74/1/0
If you've not solved this yet, especially with the special condition for things like "30_000" where the underscore is actually a space, and no one...
--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)

August 20, 2021 at 2:57 pm

#3922164
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?

Johan Bijnens wrote:
They are still image and text data types (legacy industrial tech "we will not change it for you" salesperson ). Out of row by default if I'm correct., but...
--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)

August 20, 2021 at 2:54 pm

#3922162
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?

As a bit of a sidebar, if you're going to store LOBs in the database, do yourself a favor... force them to behave as they did with the old style...
--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)

August 20, 2021 at 12:31 pm

#3922101
Reply To: How to split string and separate the data with numbers and text

Hettinger wrote:
Generic Formula to Get Position of First Number in String:
=MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},String_Ref&"0123456789")
In which dialect of SQL? That will not work in T-SQL (SQL Server).
--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)

August 20, 2021 at 11:43 am

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

P Jones wrote:
Apologies in advance for the rant but I'm fed up with developers who go to great lengths to re-invent the wheel simply because they don't know how to do...
--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)

August 19, 2021 at 7:39 pm

#3921857
Reply To: How to get the detailed record and summary value at the same time

892717952 wrote:
Sorry! next time if have the same question I'll provide sample data, thanks!
So, you're happy with the answers you got on 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)

August 19, 2021 at 7:31 pm

#3921855
Reply To: Running SQL batch file, need confirmation of execution

Erland Sommarskog wrote:
As for T-SQL job step vs. running the .Bat file, that discussion is a little more complex. It could be that NorthernSky needs to run the same set 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)

August 19, 2021 at 7:28 pm

#3921854
Reply To: How to split string and separate the data with numbers and text
sqldevlearn wrote:
I am having a set of medication where I am trying to split the data and get the required output, I have the following medications
```
ARANESP 100MCG...
```
--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)
August 19, 2021 at 5:17 pm

#3921813
Reply To: Running SQL batch file, need confirmation of execution

Why are you using a file to run a batch from? Why not a stored procedure?
Also, any chance of you posting your SQLReIndex.sql file? I ask because it appears 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)

August 19, 2021 at 3:34 pm

#3921783
Reply To: Writing a software development Proposal.

wrote:
Thanks for helping with this case. Very helpful. I also have the same situation. I will try it soon.
Heh... I smell another spammer on the horizon.
--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)

August 18, 2021 at 3:22 pm

#3921417

Reply To: Execute against all databases

SQLSACT wrote:

Hi Everyone

I have the below script which is very useful for single database usage. (Credit to the author)

How can I make this execute against all my user databases?

Thanks

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

August 18, 2021 at 3:20 pm

#3921416