Viewing 15 posts - 31 through 45 (of 179 total)
After 28, wouldn't you run out of pranks and candy?
Actually I was looking for an answer of "Between 8 and 28" because you might just get 8 randoms in a...
October 30, 2020 at 11:27 am
I can see this being useful to replace LTRIM(RTRIM()), or leading/trailing characters like commas.
Beyond that it seems to get dangerous if you are looking for more than one character to...
October 2, 2020 at 11:38 am
What a difference 4 years makes. Now people are considering moving to a better location because they can work from home. They can keep their job and still choose where...
September 18, 2020 at 11:25 am
I've been WFH since mid-March. At first I didn't like it, but I've gotten used to it. We have a spare bedroom set up as an office, so I took...
August 7, 2020 at 11:59 am
Are we being confused by the order of the operation?
WHERE 1 < @x
is functionally the same as
WHERE @x > 1
The second form is more intuitive to me, but YMMV.
July 6, 2020 at 12:21 pm
Once you get something you think is working, figure out how you would parse an address like
123 1/2 Railroad Street NW
if there were no spaces in it.
Good luck, but as...
June 25, 2020 at 1:11 pm
As Professor Hill stated, "You gotta know the territory!"
Sure, the business should need to tell us their rules. But sometimes you have to drag that out of them, so you...
June 18, 2020 at 11:45 am
Back at the beginning of my career, departments were charged for CPU time. I had a boss who found out that charges were less after hours. His plan was to...
June 18, 2020 at 11:40 am
So -100/-100*10 is being interpreted as (-100/(-100*10))
Then why is 100/100*10 interpreted as (100/100)*10) ?
June 9, 2020 at 3:01 pm
It is treating the minus signs as subtraction in precedence order.
Take them out, and the answer is 10.000...
Put the first one back in, the answer is -10.000...
But with both minus...
June 9, 2020 at 1:04 pm
Yes, it is crazy.
So if I have a statement like
SET @x = -1;
Does that mean it actually does an arithmetic operation?
June 9, 2020 at 11:23 am
Why can't you take the meaningless loop out of Function 5 and make it inline? There's no point in counting up from 0 until you reach the parameter value. Just...
May 28, 2020 at 11:34 am
...
Sometimes I do reformat it (like in the case where the developer had put all the code in one line - no CRs anywhere) to help me understand the...
May 21, 2020 at 11:10 am
One of the worst managers I had was one who never gave credit for work we did. This was only enhanced one year when the company, one of the Big...
May 18, 2020 at 11:24 am
... start date will always be the month of July. The user will select a @p_startmonth,@p_startyear and @p_endmonth,@p_endyear. ...
I just noticed this. If the start date will always be...
May 5, 2020 at 3:38 pm
Viewing 15 posts - 31 through 45 (of 179 total)