Viewing 15 posts - 1 through 15 (of 52 total)
Thank you all very much. A few different techniques, great stuff. Thanks again.
May 10, 2011 at 7:00 am
Thanks Wayne. Perfect. I'll study and use this one. Thanks a bunch!
November 9, 2010 at 1:38 pm
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...
November 9, 2010 at 1:22 pm
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...
October 11, 2010 at 3:29 pm
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...
October 11, 2010 at 1:34 pm
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...
October 11, 2010 at 11:57 am
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:
October 11, 2010 at 9:36 am
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.
August 5, 2010 at 10:19 am
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.
August 5, 2010 at 9:34 am
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)...
May 18, 2010 at 7:56 pm
Works perfectly! Thanks K.
April 8, 2010 at 1:29 pm
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...
April 8, 2010 at 12:40 pm
My answer was right (correct). As written, the only correct answer to this question is "Error". I would like my 2 points please.
March 15, 2010 at 3:23 pm
In light of all the confusion, I respectfully apologize to everyone for not making the question more clear in the first place.:blush:
January 7, 2010 at 3:05 pm
It would be most helpful for you to post :
1. Table(s) schema.
2. Sample data.
December 15, 2009 at 9:29 am