If this is in fact running on some version of OS/400 (or now IBM i) you could perhaps try to query it in SQL?

https://stackoverflow.com/questions/73732462/sql-query-to-get-db2-version-on-ibm-i

I'm not sure if you're aware of this, but when you catch an error in sp2, you're effectively annulling the error, ie. it will not automatically "bubble up" to the...

Duplicate! 🙁

• This reply was modified 11 months, 3 weeks ago by kaj.

Like this?

drop table if exists #RawInput;
go
drop table if exists #FinalOutput;
go
create table #RawInput  (
    Whatever varchar(500) not null
    );
create table #FinalOutput...

Consider changing the report from using one embedded monster query into a call to a stored procedure where you can split the original query up into several lean and mean...

• This reply was modified 1 year, 1 month ago by kaj. Reason: typos

1. At a guess I would say the difference stems from the fact that because the temp table isn't actually created and thus has no metadata the compiler can check...

• This reply was modified 1 year, 2 months ago by kaj.

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]
 ...