Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,631 through 6,645 (of 59,102 total)

Reply To: How to compare strings by letters in certain places

BOR15K wrote:
Jeff Moden wrote:
BOR15K wrote:
I need some basic help, which I will then try to extend, please.
Since very few people ever come back to tell us, I'll make you 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 15, 2020 at 7:46 pm

#3780731
Reply To: How to compare strings by letters in certain places

Post deleted... I didn't see the OP's previous post that had the answer I was looking for.

--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 15, 2020 at 7:33 pm

#3780727
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:
Gents, you can do better than that!
😎
Now think inside your (tool)box!
Heh... lordy. You need to use the tool to spell the tool...
```
 SELECT CONCAT(CHAR(838176/10000),CHAR(838176/100%100),CHAR(838176%100));

--===== Or, if...
```
--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 15, 2020 at 5:32 am

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

Eirikur Eiriksson wrote:
Gents, you can do better than that!
😎
Now think inside your (tool)box!
My brain has melted this previous week so I'm having a hard time with it.
In that same spirit, what...
--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 15, 2020 at 5:20 am

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

Lynn Pettis wrote:
I have a little bit of good news, sort of. I have managed to find work at Parsons that has extended my stay to the end of September. Better...
--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 15, 2020 at 5:16 am

#3780664
Reply To: How to compare strings by letters in certain places
Jason A. Long wrote:
Take this for a spin...
```
DECLARE
@array_6 varchar(MAX) = 'hurrah, buzzed, Bertha, patter, mettle, holler, collie, yuppie, rabble, tallow, brooks, tassel, meddle, callus, peddle, sobbed, kneels, getter, brooms,...
```
--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 15, 2020 at 5:12 am

#3780662
Reply To: How to compare strings by letters in certain places

BOR15K wrote:
Thank you, Steve
Sadly none of your examples works for me from the Studio - getting various error messages.
The code probably worked just fine for Steve. When you get such...
--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 15, 2020 at 2:09 am

#3780651
Reply To: How to compare strings by letters in certain places

BOR15K wrote:
I need some basic help, which I will then try to extend, please.
Since very few people ever come back to tell us, I'll make you a deal... Tell...
--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 15, 2020 at 2:07 am

#3780650
Reply To: Job that runs slow how to use more CPU

I'll never understand why people do this to themselves. You're talking about a batch job but you're processing using RBAR on steroids that's highly dependent on successful network traffic 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)

August 14, 2020 at 4:45 pm

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

jonathan.crawford wrote:
Jeff Moden wrote:
Eirikur Eiriksson wrote:
Did you run into those in your youth, the year looks about right 😉
Heh... I remember it well. 😀
'twas the year of Y1.9K, when all the shopkeeper's...
--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 14, 2020 at 1:20 am

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

Eirikur Eiriksson wrote:
Did you run into those in your youth, the year looks about right 😉
Heh... I remember it well. 😀
--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 13, 2020 at 4:37 pm

#3780310
Reply To: Desktop or Laptop for Remote Work

Aaron N. Cutshall wrote:
Jonathan Gennick wrote:
For the road I have a small-form-factor laptop that fits nicely on an airline tray table.
Yeah, until the yahoo in the seat in front of you decides 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 13, 2020 at 4:28 pm

#3780307
Reply To: The Hidden Trigger

Chris Wooding wrote:
It would be nice if the object explorer in SSMS had a node under each database for triggers so that you could see them all in one place.
Agreed 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 13, 2020 at 4:02 pm

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

Lynn Pettis wrote:
Phil Parkin wrote:
Lynn Pettis wrote:
IIRC, there is also a difference in the dates in Excel and SQL Server. Only problem is that I don't quite remember what the problem, had I...
--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 13, 2020 at 2:30 am

#3780068
Reply To: Change dbowner

ramyours2003 wrote:
As we renamed sa login to anothet name and want to change the dbowners of all databases but later versions like 2o12 onwards dbowner of sys databases are changed...
--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 12, 2020 at 4:06 pm

#3779315

Viewing 15 posts - 6,631 through 6,645 (of 59,102 total)