What is the transaction isolation level? Are there any triggers that might affect the data?

There appears to be no need for DISTINCT since you're using TOP 1 (correctly w/ an...

Not pure json, but this will do it:

SELECT
    SerialNumber, 
    channelIDs.value AS ChannelID
FROM
OPENJSON(@JSON)
WITH
(
SerialNumber INT '$.SerialNumber',
ChannelIDs NVARCHAR(MAX) '$.ChannelIDs' AS JSON
) AS device
CROSS...

CRLF is \r\n, which changes

[column 1], [Column A], [Column_2], [ColumnB], column3, column4, column5

to

[column 1],
 [Column A],
 [Column_2],
 [ColumnB],
 column3,
 column4,
 column5

for me in SSMS.

You should be able to use AWS CLI or SDK for language of your choice to find/inventory all EBS for each account.

You can download billing detail reports or cost/usage reports...

Performance issue when querying views across linked servers:

Linked server queries against views don't utilize statistics-based cardinality estimation. The cardinality estimation against a view is a constant value of 10,000.

If...

STRING_SPLIT() is great. But be aware of potential performance impacts of using a table-valued function or variable directly -- You may find it better to insert the values from the...

I think we know what you're asking to do.

But why would you need this in a cross-tabbed/pivoted format, especially given that you already have it in a normalized table?

How would...

What happens if you use the following to avoid the function breaking sargability (assumption: tables are indexed to support the query)

AND (cp.from_service_date BETWEEN d.eff_from AND d.eff_thru OR...

Or just do the xml query inline...

DECLARE @startTime DATETIME2;
DECLARE @endTime DATETIME2;
SET @startTime = SYSDATETIME();

DECLARE @lang CHAR(2) = 'fr';

SET @startTime = SYSDATETIME();

SELECT
    B.ID,
  ...

Your 12 months data picture didn't come through.

Please provide DDL & sample input data, & show the expected results vs. the actual results

UPDATE using a case statement -- it looks like you only have two variations.

Is the IN clause even necessary? -- i.e., does part have to be in inmast, or can...

If you used a stored procedure to do the update, you could also put history logic in the same procedure that does the update.

Triggers are a common way to maintain...

It was a known problem with multiple displays: https://blog.danskingdom.com/tell-microsoft-to-fix-the-sql-server-management-studio-connect-to-server-dialog-position/

This link suggests  just hitting escape (or enter) & then moving SSMS around allows you to get dialog in a useable...

Which version of SQL Server Management Studio?

Not SQL version/edition specific -- it happened w/ the ADS 1.40 release: https://learn.microsoft.com/en-us/sql/azure-data-studio/release-notes-azure-data-studio?view=sql-server-ver16#november-2022