Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,581 through 2,595 (of 59,067 total)

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

ratbak wrote:
What is the actual character? What does UNICODE(RIGHT(ColumnName, 1)) return? That diamond character is the unicode Specials replacement character U+FFFD: If that actually is the value stored, 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)

October 21, 2022 at 6:33 pm

#4102665
Reply To: Convert Lat/Lon Decimal Degrees to Trigesimal Codes

Ah... got it. And, it's important to avoid vowels in such a thing or you can spell some pretty nasty words. The same holds true for some of the numbers. ...
--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)

October 21, 2022 at 6:18 pm

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

@mcfarlandparkway
Asking one more time...
Jeff Moden wrote:
What is the datatype of the column that symbol appears 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)

October 21, 2022 at 3:34 pm

#4102580
Reply To: Convert Lat/Lon Decimal Degrees to Trigesimal Codes

Even if the Trigesimal codes are stored as CHAR(5), a DECIMAL(9,6) only takes up 5 bytes, as well. The Trigesimal also requires reversal if you actually want to calculate distances. ...
--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)

October 21, 2022 at 3:29 pm

#4102555
Reply To: Sum Cast to decimal gives wrong totals

@gjoelson 29755
No interest in why I asked the question that you haven't answered, yet?
--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)

October 21, 2022 at 3:13 pm

#4102550
Reply To: after insert,delete

newbieuser wrote:
Thank you so much
You're the one that will have to support all that. Do you understand why Scott didn't use any variables? Do you know why Set NoCount 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)

October 21, 2022 at 2:57 pm

#4102547
Reply To: Remote Remote Work

m60freeman wrote:
I have been working from home full-time since mid-2019, but I almost never work from other locations because as you said, the ergonomic issues are a big problem. 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)

October 21, 2022 at 2:54 pm

#4102545
Reply To: Remote Remote Work

Working from a coffee shop, even if nearby, doesn't seem to be the greatest place to work from for concentration purposes. And the reason why some companies only want 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)

October 21, 2022 at 2:49 pm

#4102543
Reply To: Generating SortColumn

I'm confused. It thought "BI" tools, like the all powerful, wonderous, "can't-live-without-it" Power BI, were supposed to make such things easy without having to write SQL for them.
Also, it's obvious...
--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)

October 21, 2022 at 2:39 pm

#4102540
Reply To: Sum Cast to decimal gives wrong totals

Ed B wrote:
gjoelson 29755 wrote:
That did the trick, I don't think I will ever have a values above 10000 so I will go with this
SELECT CAST(SUM(@OrigWeight/20000.0)*10 AS decimal(10,2)) Tons
I thought this...
--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)

October 21, 2022 at 1:30 am

#4102272
Reply To: Sum Cast to decimal gives wrong totals

gjoelson 29755 wrote:
Bingo !! Ed
That did the trick, I don't think I will ever have a values above 10000 so I will go with this
SELECT CAST(SUM(@OrigWeight/20000.0)*10 AS decimal(10,2)) Tons
But... there's always...
--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)

October 20, 2022 at 9:43 pm

#4102217
Reply To: Search for Global Temp tables in multiple stored procedures

frederico_fonseca wrote:
Lord Slaagh wrote:
Thank you for your response, but I am looking for a query that searches all stored procedures for the '##' sign. I can't manually check all of them...
--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)

October 20, 2022 at 9:01 pm

#4102197
Reply To: Why does a select on 1 table end up putting locks on other tables?

The "Search functionality" you speak of is in the upper right of this page where it says "Find out more -->" . Type something between that and the magnifying glass...
--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)

October 20, 2022 at 5:08 pm

#4102109
Reply To: Why does a select on 1 table end up putting locks on other tables?

"It Depends". Are there any computed columns or Foreign Keys associated with those other tables?
--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)

October 20, 2022 at 5:06 pm

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

What is the datatype of the column that symbol appears 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)

October 20, 2022 at 5:00 pm

#4102092

Viewing 15 posts - 2,581 through 2,595 (of 59,067 total)