In SQL Server 2019 you can also utilize the GREATEST function.

https://docs.microsoft.com/en-us/sql/t-sql/functions/logical-functions-greatest-transact-sql?view=sql-server-ver15

I now realize that my original response didn't fully appreciate that the originally case based select can't just be converted to a "normal" where clause where the criterias of the...

Well, I'm not so shocked about the lack of stored procedures as you seem to be.

The use of stored procedures for any kind of web/object oriented programming has long been...

You might get better answers if you made it more clear what your circumstances are and what you want to achieve. After all you posted your question in a forum...

Not really sure, you seem to have used the logic from IPS.InOrOut = 'O'?

I would probably start by converting the original CASE-based logic to something more standard, like

            
September 28, 2021 at 4:33 pm
            
#3934217

            
            
                                                
        

Well, I don't see a WHEN NOT MATCHED section, so how can you expect it to insert new rows?

https://docs.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver15

Try googling "tsql running total" and you will see a number of tutorials about how to do that.

Okay, I was wrong. It does seem to support proxy setup:

https://docs.microsoft.com/en-us/previous-versions/windows/desktop/ms760236(v=vs.85)

https://docs.microsoft.com/en-us/previous-versions/windows/desktop/ms763680(v=vs.85)

So you might want to fool around with those parameters, if you need to utilize a proxy in...

Is the SQL server you're using allowed a direct outbound connection to the internet?

If you're using a proxy, then this must be set up in the internet settings on the...

Hmmmm.... May I offer you a couple of alternatives that I find a tiny bit more elegant?

-- Set up test data...
DECLARE @CallLogCommonCount TABLE (
   ...

You haven't really provided actionable data about what your data looks like and what you want to achieve, but here's a wild west shot from the hip:

declare
...

• This reply was modified 4 years ago by kaj. Reason: Little typo

Maybe something like this?

with 
    tcount as (
    select codetypeid,code, count(*) as trows
    from #test
   ...

Could theoretically also be caused by a bug in SSMS. Are you using the latest version, i.e. 18.9.2?

If I misunderstood and you want the alarm noticiation flag to control the selection criteria, then it's best to use two separate queries instead of trying to cram everything into...

Uneducated guess:

DECLARE @AlarmNotification BIT
SELECT
    mpe.MeasuringPointEntryID,
    @AlarmNotification = CASE WHEN mpe.DateTimeEnd IS NOT NULL THEN 1 ELSE 0 END 
FROM [location] l
JOIN...