I don't think you are going to have a nice "one size fits all" solution here.  You are probably going to need to be creative and do multiple SUBSTRINGs or...

• This reply was modified 5 years ago by Mr. Brian Gale.

My first comment on this is with the TagName appearing in the WHERE clause, you likely don't need to worry about the CASE statement in the MAX.

Looking at the result...

I just wanted to add my vote that I have not heard the INSERTED/DELETED tables being called "magic tables" before.  I am also not sure what "deep information" you are...

That sucks for point number 1.  So you will need to dump it to DTL then convert to CSV then import to SQL which means 3 copies of the data...

Missing DLL would lead me to believe this was an incomplete install.  I would do a repair install of SSIS on that system and see if that helps.

If this is...

ScottPletcher, I agree with you.  I think what makes it difficult is that rows can have different lengths.  A VARCHAR(8000) row for example, could be anywhere between 1 byte and...

So, I don't know the exact formula, but I can answer some of the questions.

Multiplying by 1024 would be to change it from KB down to B. A single row...

I see multiple ways to handle this.  My approach would be to count the number of unique feature keys in the #settings table and store that in a variable so...

Are the customers able to export the data from the reports into something like Excel?  If so, then problem solved - push it back on them.

If they CAN'T export to...

@g.britton In a SQL a agent job, you can call to start a job asynchronously.  So one way to do it is have a 2 jobs.

Job 1 step 1 when...

If memory serves, it is because RAND() is only semi-random.  You need to provide a "seed" which will be used to make it (again) semi random.

RAND() returns a consistent list...

I'll answer things in order.

1:

Honestly, I am not certain what DTL format is, but if you need another tool to convert that to CSV, then it really depends on if...

A nice easy one for Christmas!

Merry Christmas to you and yours as well!  And thanks for all the great QOTD's!

Heh, I enjoy being called:

1 - brain

2 - clever

I feel smart!  S-M-R-T.  But Phil is correct - I prefer being called Brian.

But yes, I think that using CTE's and DATEADD...

Not from me.  I've never configured scale out for Polybase, or anything for that matter.  My systems are pretty lightweight and I've not had a need for it.

My advice -...