There's a more concise way of achieving that:

NULLIF(Divisor,0)

DROP TABLE IF EXISTS #T1;

CREATE TABLE #T1
(
    Col1 DECIMAL(19, 6) NOT NULL
   ,Col2 DECIMAL(19, 6) NOT NULL
   ,PCDiff AS CAST((Col1...

This is not a question. What is the problem?

Can you tell me another way to process xml files of greater than 2mb, I try your way to process it but still found a problem with it. My...

I've considered that, but I'd still have to find the new / modified rows and that's what this query is supposed to be doing in order to avoid having...

As you're already working in C#, that link looks good.

But, as always, you should test it to make sure it works the way you want.

As SSIS is a server-based technology, outputting messages to a console is largely pointless, as there will usually be no one there to see them. Write your messages to a...

Hi

First: Use in your SP Begin try and begin catch SQL Satements.

For eq.

Begin try

Update Tabelle

Set field= 1/0

Where field2=1

--here rais an error because Division durch zero

Ende Try

Begin catch

-- here you...

This sort of thing is best done in the report (ie, at presentation time) rather than in the query.

As the statement preceding WITH in the definition of a CTE must be terminated by a semicolon, it cannot follow EXISTS or APPLY.

I do not know the answer to your question, but I do have a couple of questions about your solution architecture.

1. Have you considered dumping all of the new/modified rows...

The usual protocol in this forum is to leave your original post intact and instead to make another post explaining what the issue was and how you resolved it. This...

Trimmed down your code a bit. Works for me.

DROP TABLE IF EXISTS dbo.CTR_PanelMembers;
DROP TABLE IF EXISTS dbo.CTRs;

CREATE TABLE dbo.CTRs
(
    CTRseqNo INTEGER IDENTITY(1, 1) NOT...

Please format your code in future.

As you have not included desired results, I have no idea what you are trying to achieve. But this query runs, at least.

            
February 10, 2022 at 11:27 am
            
#3981690

            
            
                                                
        

Single quotes are for chars. Use double quotes for string literals ... it should work.