This should work, I think:

UPDATE t
SET t.CarStatus = '2'
FROM #Test t
INNER JOIN (
    SELECT CarID, MIN(Id) AS Id
    FROM...

Or maybe even better, simply reverse the order of the join criteria? Might work... 🙂

SELECT a.a3ltrcode, b.CommentCode
FROM a3ltrcodeTBL a
INNER JOIN Comments b ON a.a3ltrcode =  
...

• This reply was modified 4 years, 3 months ago by kaj.

I have a table with 3 letter codes, and I have a comment table with comment codes. The comment code used is dependent on the 3 letter code. So...

Yes, I meant that. I really can't believe I reached out for help and...

• This reply was modified 4 years, 3 months ago by kaj. Reason: Typo
• This reply was modified 4 years, 3 months ago by kaj.

Huh??

Oh, I think you mean the comment by Joe Celko about your low score etc., even if you didn't quote that. At least I hope you didn't refer to my...

• This reply was modified 4 years, 3 months ago by kaj. Reason: corrected typo - meen --> mean

I would probably create a mapping table between City and Region:

create table dbo.City2RegionMap (
    City varchar(20) not null,
    Region varchar(20) not...

• This reply was modified 4 years, 3 months ago by kaj.

This should work, I think:

UPDATE t
SET t.CarStatus = '2'
FROM #Test t
INNER JOIN (
    SELECT CarID, MIN(Id) AS Id
    FROM #Test
 ...

• This reply was modified 4 years, 3 months ago by kaj. Reason: Changed SET CarStatus = 2 to SET CarStatus = '2'

I'm not a SSRS expert. I know enough to get myself in trouble. Anyway, if memory serves, I recall seeing somewhere a blog post, maybe a Microsoft...

/* Setting up test data */
declare @sales table (
    DMDUNIT char(1),
    U_ONSALE_DATE date
    )
insert into @sales (DMDUNIT, U_ONSALE_DATE)
 ...

... or maybe this one?

select
    js.job_id,
    j.name,
    js.last_outcome_message,
    jst.subsystem,
    jh.step_id,
  ...

• This reply was modified 4 years, 3 months ago by kaj. Reason: typo

What about this one?

SELECT 
    j.job_id AS FailedJobId,
    j.name AS FailedJobName,
    jh.instance_id AS FailedJobInstance,
    jh.run_date...

Since you're on SQL Server 2019, you shouldn't need to use XML and STUFF etc. any more - you can use the STRING_AGG function, which became available with SQL Server...

And yet, I've not seen where that actually matters.  And, it won't matter unless you're doing RBAR updates of the same row more than once every 3.3 milliseconds because...

Okay, that's an...

• This reply was modified 4 years, 3 months ago by kaj. Reason: column -> columns (TYPO)

Or better yet, store them as datetime2(0), which...