Thank you all very much. A few different techniques, great stuff. Thanks again.

Thanks Wayne. Perfect. I'll study and use this one. Thanks a bunch!

Hey thanks for the reply.

The break scans are actually a single table. The actual table contains millions of rows with many scan-types (I just need the 3 and 4...

For purposes of this exercise, the guids are irrelevant. Trying to keep it simple but have too many irons in the fire. I appreciate you sticking with me Drew. The...

Thanks for your reply Drew. I did remove the redundant call to tblControlLog but the performance against the presentation data is still too sluggish. Any help with a new perspective...

Thanks for the response, but this is exactly (nearly) what I already have. I'm looking for an alternative to this. My query runs approx 75% faster when I remove the...

Not sure how this would work into your transformation but just going on what you've provided, the case statement would be something like this:

SELECT

CASEWHENNAMEIS NULL

THENNULL

ELSEID

ENDASDEG_ID

FROM DEG_TABLE

Thanks for catching that. I should've spotted it. This works.

ABS(CONVERT(BIGINT,(DateDiff(minute, s.dteCrtTS, s.dteAssignEndTS)))*60)

Wish I had time to dig into what differences are causing this.

Thanks Guys!

The data type is datetime.

When I use ABS(CONVERT(BIGINT,DateDiff(mi, s.dteCrtTS, s.dteAssignEndTS)*60))

I get: Arithmetic overflow error converting expression to data type int.

It's most certainly not the best solution but it fixes the problem. Altered slightly my final select...

.

.

.

----------- Re-build the description ------------

SELECT STUFF((SELECT DISTINCT ', ' +

CAST(CASEWHEN CHARINDEX(',', String,1)...

Works perfectly! Thanks K.

Thanks. I suppose I don't have to go to seconds, but my hh:mm:ss.mmm conversion functions (report-side) are already built and based on seconds. However, that aside, my problem centers around...

My answer was right (correct). As written, the only correct answer to this question is "Error". I would like my 2 points please.

In light of all the confusion, I respectfully apologize to everyone for not making the question more clear in the first place.:blush:

It would be most helpful for you to post :

1. Table(s) schema.

2. Sample data.

Thanks.