Hi Phil.

Many thanks for coming back on this. It drives me crazy...

It happens at least in VS 2019 and 2020, which I've checked. I have several tables with such...

If the data really is as well structured as your examples suggest, the following should work. If not, something more refined will be required.

DROP TABLE IF EXISTS...

I need to parse payment data from a notes field. Example of data below.  I tried the Len function but got mixed results, Any help or examples would be...

The column is defined for every row of data in the table, therefore the idea of...

Which version of SSDT?

Have you got any other tables with clustered columnstore indexes on them? Is there something special about this table, or does it happen for every table like...

I suggest it's worth having both 32- and 64-bit versions installed.

Take a look here to see how to do that (it's not as straightforward as you might think).

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