I've seen this "constant" "equality test / compare" "expression" used in other languages, and its a thing due to (in some languages) the inherent ambiguity between "=" the test and...

I don't approve of doing this – it wouldn't get past me in a code review – but you can do something like this:

BEGIN TRY
 ...

• This reply was modified 5 years, 3 months ago by x.

The U.S. Congress decided (wisely for once) that they wanted people to want to stay home without worrying about the bills. So they authorized an extra $600.00...

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. ...

I think we have to suck it up with this "mobile first". Obviously the smart move would be to serve up a mobile site when a mobile useragent presents itself...

I feel like I'm missing something. An inner join is necessarily an existence check, why not:

SELECT u.UserId
  FROM UserTable u
  JOIN TableA a ON...

This would not work,...

All of them.  The system is only 9 months old.

Lynn, there are a...

Okay, so TableA and TableB in the derived table are those two source tables where the login info may exist. So why the distinct in the outer query when there...

All of them.  The system is only 9 months old.

Lynn, there are a lot of...

Okay, so TableA and TableB in the derived table are those two source tables where the login info may exist. So why the distinct in the outer query when there...

I suspect that's not the only exaggeration LOL

Now is someone going to rewrite that query or not?

Here's the query.  There's not any understanding on how the the language works, index usage (or lack of usage), and what these things do.

It works in dev,...

Here's the query.  There's not any understanding on how the the language works, index usage (or lack of usage), and what these things do.

It works in dev, why...

make sure you don't attend in person!