I have had situations where I simply couldn't make a execute using WITH RESULT SETS work.

I solved the issue by changing the sp to specify a dummy table variable with...

Based on ratbak's second query, I think you can simplify it a little more by using a combination of AVG and NULLIF:

WITH subquery AS 
(
SELECT 
 ...

I'm not really familiar with Oracle, but this seems like something universal, so I will give it a try.

SELECT Id,
       SUM(CASE...

Just remove the GO - there's no need for it.

SET @view_code = N'CREATE VIEW [' + 'PGCPS_CUSTOM' + '].[' + @table_name + '_VW] ' + @line_break +

'AS ' + @line_break...

Long shot: Have you changed the batch separator to something different than the default? That would produce the error you describe.

In SSMS check

Tools-> Options -> Query Execution -> General

and

Query... ->...

No, only VB.NET and C#.NET is supported.

https://learn.microsoft.com/en-us/sql/integration-services/control-flow/script-task?view=sql-server-ver16

Options

ScriptLanguage

Select the scripting language for the task, either Microsoft Visual Basic or Microsoft Visual C#.

I don't think there is a pre-baked recipe for you, but FWIW, Brent Ozar has a few recommandations, which you can read about in this blog post:

https://blog.quest.com/demystifying-cxpacket-and-cxconsumer-wait-types-in-sql-server/

Sorry, but you've been extremely sloppy with your example code/data.

1. The insert into statement can't even pass a parse test.
2. There are different column names used in the table and...

... but if you can't change the date format in the file name...

This would also be a possible solution:

DECLARE @x VARCHAR(100) = '09142023';

SELECT @x as [@x]
 ...

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 11 months, 1 week ago by  kaj. Reason: SQL formatting
• This reply was modified 11 months, 1 week 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 11 months, 1 week ago by  kaj. Reason: added "on the same column" to avoid ambiguity