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 years, 9 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.

Please stop spamming. This is not the forum for that.

Marking your post as spam. Every single post you make is promoting the same solution!

This looks suspiciously like spam. To prove yourself, please explain the interaction between this product and SQL Server...

I'm actually not too concerned about opening xlsx files, as they can't contain executable code (as far as I know). I downloaded and virus-scanned this one before I opened it.

Is...