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

Is there any additional way of limiting TicketOpenDate?

Eg, are you looking for only those open in the last week or month, rather than going back over all time?

This is how my table looks except I used random numbers for my values. Some of the dx columns have values and some do not. How about actually showing...

Can you show us the T-SQL which generates this?

Using ROW_NUMBER() might do what you want, but I can't be sure.