Jeff Moden (12/22/2012)
neevmansoori (12/22/2012)
We sincerely thank you..It Saves a lot of Efforts of mine.:-)
Yeah, but as old as this post is, I'm not sure that it answers what needs to be done for display purposes if the following data is present...
Connect Time2 totalTime2
23:00:00.0000000 01:00:00.0000000
I think what Jeff is alluding to without saying it is the TIME data type is a "time of day" and not a "time duration." Adding them together implies that at least one of the values is a "time duration." How can you add 4PM + 6PM?
Perhaps though, it has some meaning in another multiverse.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St