Maybe the application settings for SQL within the Application is different than what I'm running in SSMS

That was my first thought. You should check this.

There must be a more elegant way of doing this, but I ran out of time. This appears to work with the existing data:

WITH filtered
AS (SELECT p1.Code
...

Looks promising, but I haven't used it.

You need to start doing some R&D.

Once you figure out how to code the REST calls you need, whacking that code into SSIS isn't...

Did you try Jonathan's code?

As far as I know, C# cannot do this conversion natively.

NitroPDF does not appear to have an API, so its functions cannot be called from other applications. You'll have to...

Here's a possible way. It assumes that if a hyphen appears anywhere in the underlying text string, it must mean that the string is a negative number.

DROP...

I've made the test data generation a little more user-friendly (and changed the 'Code' for the second set of data to differentiate from the first)

DROP TABLE IF...

• This reply was modified 1 year, 7 months ago by Phil Parkin.

Probably larger than you need, but should be fine.

oh one more quick question - what size should I make the VARCHAR datatpe that will hold the decimal value my temp table? Or would TEXT datatype do the...

• This reply was modified 1 year, 7 months ago by Phil Parkin.

If using SQL Agent ...

One way is to create a log table and log the errors there and then make sure that the Agent job fails if one or more...

What automation tool will you be using for this process?

No danger at...

What tool are you using to import? Can it 'look for' trailing minus signs and move them to be leading as part of the import?

Or perhaps you will have to...

Hi as in other forums but possibly worse, there doesnt seem to be an easy way to show just my posts in this forum.  If i search on my...

Something like this?

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
    Col1 VARCHAR(100) NOT NULL
   ,Col2 VARCHAR(100) NOT NULL
);

INSERT #SomeData
(
    Col1
...