Viewing 15 posts - 7,231 through 7,245 (of 7,602 total)
Why does the float value change to a smaller number when the precision increases?
Maybe just the general nature of floating point values, that they are approximations only.
September 7, 2012 at 3:50 pm
I am completely unable to get the float value to cast or convert to a varchar and not truncate it
From BOL:
"By default, the precision of built-in operations on float data...
September 7, 2012 at 3:44 pm
Lynn Pettis (9/7/2012)
CREATE TABLE #tblTemplates
(
...
September 7, 2012 at 2:51 pm
SELECT TemplateID
FROM #tblBlocks
GROUP BY TemplateID
HAVING COUNT(DISTINCT CASE WHEN #tblBlocks.BaseStage = 1 THEN BlockID END) = COUNT(DISTINCT BlockID)
September 7, 2012 at 12:40 pm
sku370870 (9/7/2012)
SELECT Distinct #tblTemplates.TemplateName FROM #tblTemplates
INNER JOIN #tblBlocks ON #tblTemplates.TemplateID = #tblBlocks.TemplateID
INNER JOIN (SELECT TemplateID, BlockID
...
September 7, 2012 at 12:06 pm
TimeResult1 = -- ChrisR (5 date functions, 2 datatype conversions)
TimeResult2 = -- ChrisM (5 date functions, 2 datatype conversions)
...
September 7, 2012 at 12:00 pm
SELECT BlockID
FROM #tblBlocks
GROUP BY BlockID
HAVING MAX(CASE WHEN BaseStage = 1 THEN 1 ELSE 0 END) = 0
Include the TemplateID in the SELECT and GROUP BY if required.
September 7, 2012 at 11:37 am
bmahf (9/6/2012)
September 6, 2012 at 3:18 pm
Lynn Pettis (9/6/2012)
Steven Willis (9/6/2012)
ScottPletcher (9/6/2012)
return an INT value, which at a precision level of 7 gets overflowed.
The INT can't overflow returning billionths of a second -- the max possible...
September 6, 2012 at 2:08 pm
return an INT value, which at a precision level of 7 gets overflowed.
The INT can't overflow returning billionths of a second -- the max possible value is 999,999,999, which is...
September 6, 2012 at 1:09 pm
Jeff Moden (9/6/2012)
ScottPletcher (9/6/2012)
I don't think audit triggers are relevant any more, given the better options built into SQL itself now.I've not found those options to do so well.
Interesting. ...
September 6, 2012 at 9:45 am
Jeff Moden (9/6/2012)
September 6, 2012 at 8:52 am
It doesn't need a trigger because the data doesn't change, it just needs to be cleaned up.
But the trigger DOES the clean up, which guarantees that (1) it occurs and...
September 5, 2012 at 3:49 pm
Sean Lange (9/5/2012)
To me that is vastly better than using LTRIM/RTRIM on all subsequent queries!
You certainly have a valid point. Not sure that adding an insert/update trigger on every table...
September 5, 2012 at 3:14 pm
To be fair, higher precision in intermediate calculations in complex equations can in fact cause errors rather than solving them.
I'm certainly no authority on currency laws, so I can't speak...
September 5, 2012 at 3:12 pm
Viewing 15 posts - 7,231 through 7,245 (of 7,602 total)