Make the filename use the international ISO format YYYYMMDD instead of that quaint american date format and you'll have no trouble at all. 🙂

That's not the intent of the "quiet" switch.  The intent...

One comment: I hope the example table isn't an exact replica of your production table, because to use that many columns defined as nvarchar(max) just to be on the safe...

... and here's my attempt at fulfilling your requirements:

/* Load the test data */

DROP TABLE IF EXISTS #SecurityUsers;

CREATE TABLE #SecurityUsers (
    SecCode NVARCHAR(70) NOT...

• This reply was modified 2 years, 3 months ago by kaj. Reason: SQL formatting
• This reply was modified 2 years, 3 months ago by kaj.

Have you changed the target server of the SSIS package to SQL Server 2019, done a Rebuild and deployment? If the target server of the package is still set for...

This is not an aswer to your question, but...

Your criteria AND (ITPRDC != 'AX' OR ITPRDC != ' ') looks wrong to me. And it's not your use of the...

• This reply was modified 2 years, 3 months ago by kaj. Reason: added "on the same column" to avoid ambiguity

Yes, 'BL.2112.00627' isn't the same as 'BL.2111.00627', so not surprising that you may get different results from the two queries. 🙂

As the OP want an opinion about the two code options presented, i.e.

Option 1:

DECLARE @strcol1 varchar(max), @intco11 int

SELECT @strcol1 += ','+CAST(col1 AS VARCHAR(20)),  @intco11=col1 
FROM (
...

Or you could dispense with some paranteses, like this:

IF EXISTS (

SELECT DISTINCT UPC,  U_PUBLISHER_TYPE
FROM [snapshot]
LEFT OUTER JOIN [item] 
ON [UPC]=item.[ITEM]
WHERE item.U_PUBLISHER_TYPE IN ('PRPG', 'RMSP', 'RDSP')

EXCEPT

SELECT DISTINCT...

Unless the "with the matching dates" is to be interpreted as a date range selection, in which case Jeff Moden's integer math would be needed to ensure that the 24...

• This reply was modified 2 years, 6 months ago by kaj. Reason: Forgot a couple of t. column prefixes

And now we're just waiting for Google's Bard chatbot to go to GA. Time will tell who is the more truthful chatterbox.

But Bard will probably not do any better, since...

It apparently cannot make the distinction between "temp tables" and "temporary tables".  It's seriously incorrect for what most of us refer to as "temp tables" and...

It apparently cannot make the distinction between "temp tables" and "temporary tables".  It's seriously incorrect for what most of us refer to as "temp tables" and seriously correct for...

Sorry, but that's not valid JSON.

Generally, what most people do, is to flatten the structured JSON into one table, which can later be queried and grouped.

Alternatively you can also use...

Dear All,

My one condition is working like if data exist than it should fail only one condition is pending that is "if data exists without qty, than qty should...

• This reply was modified 2 years, 7 months ago by kaj.
• This reply was modified 2 years, 7 months ago by kaj.
• This reply was modified 2 years, 7 months ago by kaj. Reason: typos, typos and yet another typo, sorry!
• This reply was modified 2 years, 7 months ago by kaj. Reason: changed/improved the first IF NOT EXISTS query slightly