Sorry, I have explained that badly. It definitely isn't a bug in SQL, but it can cause a bug in my software (if I change from ISNULL to COALESCE and...

or ... I have seen people just put a physical whiteboard behind them, in view of the camera, and just write on that.

Stops anyone else in the meeting drawing on...

That's...

Thanks Brian ... but you are not selling it to me!

To do a proper job I would need to have ability to resend a message e.g. audit log kept for...

The same argument that @Kristen makes for changing IIF to a CASE expression applies to ISNULL - are you going to change ISNULL to COALESCE when the requirements change...

Michaels suggestion was probably this

SELECT[Date] = MAX([Date])
, city
, area
, Status
FROMMyTable
GROUP BY city
, area
, Status

which is a lot more skinny, provided that your code isn't more complicated than...

SELECT[Date]
, city
, area
, Status
FROM
(
SELECT[T_City_RowNumber] = ROW_NUMBER()
OVER
(
PARTITION BY city
ORDER BY [Date] DESC
)
, [Date]
, city
, area
, Status
FROMMyTable
) AS T
WHERET.T_City_RowNumber = 1

EDIT : I had to remove the square brackets...

Very helpful Brian, thanks. I have almost no experience of Service Broker, but we have 3rd party APPs/DBs that use it.

I have a 3rd party database where I want duplicated...

Something like this maybe

SELECT[RowNo] = ROW_NUMBER()
OVER
(
ORDER BY [Date]
)
, [Column1] = CASE WHEN DayOOS IS NOT NULL AND [T_Column1] = 1 THEN [Date] ELSE NULL END
, Id
, [Date]
,...

I would write a FUNCTION and use that to "wrap" each of the columns, then if you find "something else" that you need to be...

You've doubled up the output columns, I presume that is just a typo?

but ... that apart ... test it 🙂

            
February 27, 2021 at 6:06 am
            
#3850907

            
            
                                                
        

I dislike IIF ... its "familiar" for people that use similar functions in Excel, but I think CASE is better in SQL

IIF only has two outcomes, true/false, and to get...

When I worked at a utility in 1991, we bought a server for US$250,000. I couldn't believe it. Wasn't sure it was worth it, but it certainly made a...

That's the part that bothers me ... why a single statement is not, inherently, atomic.

Can I be sure I have covered...

Is this atomic in this situation? (My recollection is that it is NOT, without appropriate LOCK hint)

insert into log_test1
select(SELECT MAX(c1)+1 FROM log_test1)
, @v3