Can you please confirm this statement:

1 record has match is 2 because it has in 2 subsequent previous month data was there with mainhost

You are referring to the 2023-12-31 row,...

Then perhaps you will find this informative: https://aws.amazon.com/compare/the-difference-between-sql-and-mysql/

You've been here long enough to know the forum etiquette: please re-post your original question and its solution. This may come in useful to others.

First, please note that this is a SQL Server forum, not MySQL.

In T-SQL, I'd do something like this

DROP TABLE IF EXISTS #wp_um_metadata;

CREATE TABLE #wp_um_metadata
(
   ...

--Removed duplicate

• This reply was modified 1 years, 11 months ago by Phil Parkin.

No. As demonstrated below.

DROP TABLE IF EXISTS #x;

CREATE...

This will be easier to answer if you provide the DDL for the underlying table, including PK and Index definitions. If the query really is as simple as you suggest,...

Possibly because the prod environment...

What is the text of the error you are receiving?

Is the data exactly the same across the different environments?

You need to find out more from the person asking you to do this. Questions such as

What sort of validation? Data within certain limits? Data has only predefined values? Data...

Wow, don't be offended, but what a mess! It might be time to think about a divide and conquer approach. Build up your result sets individually and then assemble them...

• This reply was modified 2 years ago by Phil Parkin.

We can't even properly see your query! How is anyone supposed to know what code is in that function?

After...

• This reply was modified 2 years ago by Phil Parkin.

What is the datatype of SERVICE_CD? CASTing every element to VARCHAR(MAX) sounds like madness.

Your DISTINCT is applied to the result of the STRING_AGG, not to the elements it contains.

Remove the dupes in a CTE and select your STRING_AGG from that.