Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,196 through 3,210 (of 59,086 total)

Reply To: Please help to get, Alphabet with underscore i.e special charecter

Steve Collins wrote:
Afaik this actually produces the desired output. Should work with SQL 2014. It uses the ordinal splitter DelimitedSplit8K_Lead. The query: splits the input string on '_' underscore, finds 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)

July 14, 2022 at 2:00 pm

#4063292
Reply To: Please help to get, Alphabet with underscore i.e special charecter

ScottPletcher wrote:
A couple of potential issues: if there's an additional period (.) in the file name and/or an underscore in the extension.
At least it produces the correct output when 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)

July 14, 2022 at 12:59 pm

#4063272
Reply To: How to get last 5 weeks start and end dates

mcfarlandparkway wrote:
Example - When i run the query today 7/13/2022
I am looking for start and end dates to be June 11, 2022 that is saturday to July 9, 2022 saturday....
--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)

July 14, 2022 at 2:49 am

#4063051
Reply To: Please help to get, Alphabet with underscore i.e special charecter

@dba-2.k ,
Look again. None of the code posted actually produces the desired output that you posted. "Must look eye".
--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)

July 13, 2022 at 11:11 pm

#4063013
Reply To: Please help to get, Alphabet with underscore i.e special charecter

kaj wrote:
Jeff Moden wrote:
With the understanding that I've not done any deep analysis on any of the code posted and going only on what I've seen in the past, the nested...
--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)

July 13, 2022 at 11:00 pm

#4062998
Reply To: Linked Tables Excel

I don't know much about your issue but... are you saying that it won't even let you build a linked server and does your linked server cite a specific file?
In...
--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)

July 13, 2022 at 9:14 pm

#4062968
Reply To: How to Find the Start and End Dates for the Current Week (and more)

Awesome feedback, Tom. Thank you both for the read and the feedback. I really appreciate it.

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

July 13, 2022 at 8:42 pm

#4062963
Reply To: How to Find the Start and End Dates for the Current Week (and more)

Thanks for the feedback, especially on the experiences you've had in the past and especially about the "Middle of Week" thing.
Of course, many thanks for the catch on the typo. ...
--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)

July 13, 2022 at 4:19 pm

#4062847
Reply To: Azure Pricing, SQL Server seems pretty high?

Heh... I get that same response (none) to that question a whole lot. 😀

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

July 13, 2022 at 4:01 pm

#4062844
Reply To: Remove 6 digits and 8 digits from texts

~~You need to fix the example you posted. You tried to obfuscate some information with a Magenta Marker but it was actually a hiliter and we can read the data...~~
--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)

July 13, 2022 at 3:43 pm

#4062830
Reply To: Please help to get, Alphabet with underscore i.e special charecter

With the understanding that I've not done any deep analysis on any of the code posted and going only on what I've seen in the past, the nested REPLACEs that...
--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)

July 13, 2022 at 3:41 pm

#4062829
Reply To: How to Find the Start and End Dates for the Current Week (and more)

Thanks for the feedback, Kazoo! I appreciate it.
--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)

July 13, 2022 at 3:07 pm

#4062801
Reply To: How to Find the Start and End Dates for the Current Week (and more)

(Sigh...) My apologies, folks. I spent a couple of hours manually color coding all of the code because I knew the "code windows" on this site makes a bit 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)

July 13, 2022 at 2:00 am

#4062472
Reply To: Database backup sequence

First things first... ALWAYS read the Microsoft Documentation on such things. Here's the link so there's no excuses on the prime duty of a DBA...
https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql
Second, look at the options......
--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)

July 12, 2022 at 9:01 pm

#4062391
Reply To: Best Swift IDE\'S

I checked the link in the response and got "Malicious Site Blocked" warning and so hit with the spam button. And, yea... I subscribed to the original post as soon...
--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)

July 12, 2022 at 7:47 pm

#4062347

Viewing 15 posts - 3,196 through 3,210 (of 59,086 total)