Viewing 15 posts - 2,566 through 2,580 (of 59,067 total)
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. ...
October 21, 2022 at 6:18 pm
Asking one more time...
What is the datatype of the column that symbol appears in?
October 21, 2022 at 3:34 pm
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. ...
October 21, 2022 at 3:29 pm
@gjoelson 29755
No interest in why I asked the question that you haven't answered, yet?
October 21, 2022 at 3:13 pm
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...
October 21, 2022 at 2:57 pm
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...
October 21, 2022 at 2:54 pm
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...
October 21, 2022 at 2:49 pm
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...
October 21, 2022 at 2:39 pm
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...
October 21, 2022 at 1:30 am
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...
October 20, 2022 at 9:43 pm
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...
October 20, 2022 at 9:01 pm
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...
October 20, 2022 at 5:08 pm
"It Depends". Are there any computed columns or Foreign Keys associated with those other tables?
October 20, 2022 at 5:06 pm
What is the datatype of the column that symbol appears in?
October 20, 2022 at 5:00 pm
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...
October 19, 2022 at 5:24 pm
Viewing 15 posts - 2,566 through 2,580 (of 59,067 total)