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

• This reply was modified 3 years, 10 months ago by kaj. Reason: Typo
• This reply was modified 3 years, 10 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 3 years, 10 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 3 years, 10 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 3 years, 10 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 3 years, 10 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 3 years, 11 months ago by kaj. Reason: column -> columns (TYPO)

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

I'm not fluent in the SSRS VBA syntax, but that replace looks strange. I think you need only the "inner" parameters, i.e.

=Replace(Fields!Justification_Text.Value," ","")

But since the error message mentions the VT...

• This reply was modified 3 years, 11 months ago by kaj. Reason: Changed 0X0B into 0x0B

I'm sorry about the misinformation. I didn't pay attention to the list of "Applies to" services.

I remembered some excited chatter some months ago about the functions now being available, but...

Without knowing your data, it might be as simple as that the VT control character is used in your column to indicate a line break, instead of the more "normal"...