I would reach out to the vendor of the BODS tool myself.  I expect that the tool has a timeout (possibly the default) for keeping the connection open to SQL. ...

I can't see any reason why it wouldn't work as long as @CurrentToken is defined.  I've run stored procedures inside an SSRS report.  I think it needs to return a...

I agree with Jeff here - find the problem queries and you will find the performance problems.  fix the problem queries and you will likely fix the performance problems.

The exception...

CTE's are not the only way to do it.  Nested selects would be another option, or you could do the calculation outside of SQL at the application layer, or you...

So, I think the problem you are having is that you are doing the update based on a VARIABLE not a COLUMN VALUE.  Change:

 UPDATE [dbo].[DTable] SET...

One thing to be cautious of that I didn't think of until today (just now) - AFTER getting the "final" string, you may want to check for a WHERE clause...

My goal was not to "stump" the interviewee, but to see if they had knowledge of SQL Joins and if they could do basic problem solving based on the words...

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, 2 months 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...