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

How about you testing instead? That's what I do when things aren't working as expected.

You've created a few...

I just tried this, and for me the blocking occurs, exactly as you expected.

Why have you posted this again?

Duplicate post, original here: https://www.sqlservercentral.com/forums/topic/run-time-error-at-system-runtimemethodhandle-invokemethod

Step-by-step debugging is what I would suggest.

I suggest that you compare the schemas of the temp tables with those of the permanent tables and you'll see for yourself.

Alternatively, create the temp tables explicitly (using CREATE TABLE...

easy - would help if you had created a script task (as instructed on the link) instead of a script component.

so do it correctly - script component does NOT...