Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 59,098 total)

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
Reply To: Data Lineage Scripts for Microsoft SQL Server and Azure SQL

That's a part of why I cringed so hard that it hurt when they announced they were shifting to a WordPress platform on the last change for the WebSite 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)

October 19, 2022 at 5:24 pm

#4101606
Reply To: Exclude Weekends and Holidays

ktdickinson wrote:
Hello from 6 years in the future! Just want to say thanks for sharing your SQL code, which solved a seemingly complicated business problem for me. I'm working with...
--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 18, 2022 at 6:05 am

#4100806
Reply To: The Digital World Remaking the Analog One

Steve Jones - SSC Editor wrote:
Perhaps, but I'm not sure that's the case. A lot of things we thought were private in the past, actually weren't private. What happened was the data was too...
--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 18, 2022 at 5:49 am

#4100803
Reply To: Where did all of the SQL Server DBAs go?

Ken McKelvey wrote:
Reminds me of sitting in a meeting with some of my colleagues and having to keep a straight face when it was my turn to incorporate the next phrase...
--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 17, 2022 at 11:02 pm

#4100734
Reply To: Linked Server With SQL Authenticated Users

Kerberos?
Or maybe the app simply isn't passing the credentials correctly?
--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 17, 2022 at 2:36 pm

#4100543
Reply To: The Digital World Remaking the Analog One

It's pretty amazing how this type of thing is actually an invasion of privacy, especially on the highways.
--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 17, 2022 at 2:30 pm

#4100539
Reply To: How to Append Character to Field Values

I can also tell you for sure that the "community member"s name was not Jeff Morden. 😀
--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 17, 2022 at 12:14 am

#4100274
Reply To: I need a T-SQL script to find, for a given view across all databases, which ...

Totally understood and, I never thought I'd say this, but this is for a "one-off". I'll invest some time in a better one later. And, I totally agree with 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)

October 16, 2022 at 9:07 pm

#4100251
Reply To: I need a T-SQL script to find, for a given view across all databases, which ...

sgmunson wrote:
Haven't been able to quickly find something online that solves it...
30 second search https://duckduckgo.com/?q=find+column+name+in+all+databases+sql+server led to the following:
https://sqlserverplanet.com/dba/find-column-in-all-databases
Hope it helps.
--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 15, 2022 at 10:47 pm

#4100067

Viewing 15 posts - 2,626 through 2,640 (of 59,098 total)