Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,536 through 2,550 (of 59,098 total)

Reply To: Display values from ntext defined field
1. Read the NTEXT into an NVARCHAR(MAX).
2. Use a Tally table function to read each character. If it's not the letters A-Z or a-z or 0-9 or common symbols, then...
--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)
November 11, 2022 at 5:30 am

#4111255
Reply To: How to summarise values in hierarchies

Please see the following article to easily do exactly what you ask.
https://www.sqlservercentral.com/articles/hierarchies-on-steroids-2-a-replacement-for-nested-sets-calculations-1

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

November 11, 2022 at 5:25 am

#4111254
Reply To: Non Clustered Index

IMHO, the best thing said on this thread is...
Grant Fritchey wrote:
Measuring performance before and after the addition of the index and an examination of your execution plans (which are not 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)

November 11, 2022 at 4:20 am

#4111234
Reply To: SSMS csv export file is missing leading zeroes for Numeric data types

squareoff wrote:
Hi Jeff,
Without the leading zeroes (e.g. instead of 0.123 it would show in the .csv file .123), I could not load the file into BigQuery. Import function was giving...
--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)

November 9, 2022 at 9:52 pm

#4110725
Reply To: Remove certain unknown amounts of character from a string

Eirikur Eiriksson wrote:
Have a look at this thread
😎
That's a long thread. You might want to provide the post number for where we ended up on that 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)

November 9, 2022 at 6:41 pm

#4110668
Reply To: Remove certain unknown amounts of character from a string
If it will always be that you have a non-numeric first character and the rest are numeric, this will work very quickly...
```
 SELECT CONVERT(INT,SUBSTRING(yourstring,2,8000))
```
--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)
November 9, 2022 at 6:40 pm

#4110667
Reply To: SSMS csv export file is missing leading zeroes for Numeric data types

I have to ask... why is it important to have leading zeros on this particular bit of numeric data in the CSV? Or is it not a CSV file after...
--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)

November 9, 2022 at 6:33 pm

#4110666
Reply To: Auto assign Column Data Types for Flat file Source Import

I agree that this is a great solution and some fine "out of the box" thinking for SSIS.
My problem with it all though is, you already know what the definition...
--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)

November 9, 2022 at 3:55 am

#4110319
Reply To: Analyzing a huge ( more than 10600 lines )stoc proc using cte

Peel one potato at a time. Like Ratbak suggests above, it will require a "Diligent Data Engineer". One of the best things to make as you go along, is 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)

November 9, 2022 at 3:43 am

#4110317
Reply To: DevOps is Culture

Eric M Russell wrote:
DevOps is a collection of tools and processes for deploying code.
IMHO... that's what the word has come to mean but not for me. You can have all the tools...
--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)

November 8, 2022 at 6:59 pm

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

I'm thinking that they've stretched Steve a bit too far... I can't even get an acknowledgment to the two emails that I've sent the WebMaster about the email notifications.
--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)

November 7, 2022 at 7:22 pm

#4109744
Reply To: DevOps is Culture

I guess DevOps has degraded to the point where you can't even get an acknowledgement to a site problem sent to the WebMaster because there's too much DevOps going 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)

November 7, 2022 at 7:15 pm

#4109743
Reply To: SAP S/4HANA and Microsoft Azure SQL integration and ETL DELTA Process

This isn't the place to post an article. This is a thread for people to request articles or post article ideas. Hopefully, though, the WebMaster will see this and respond...
--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)

November 5, 2022 at 9:45 pm

#4109138
Reply To: Extracting first characters in a string

Jonathan AC Roberts wrote:
Jeff Moden wrote:
As a bit of a sidebar, you may have some people come back with a suggestion of using the built-in STRING_SPLIT() function. That will seem to work 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)

November 5, 2022 at 8:28 pm

#4109122
Reply To: How to remove diamond character from string in sql

At McFarlandParkway,
Are you all set? Did the solution I posted work for you?
--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)

November 5, 2022 at 8:26 pm

#4109121

Viewing 15 posts - 2,536 through 2,550 (of 59,098 total)