Viewing 15 posts - 7,216 through 7,230 (of 7,597 total)
GilaMonster (9/12/2012)
Well, both of those statements are incorrect, so probably better to just ignore them...
Quite true.
September 12, 2012 at 4:27 pm
Lynn Pettis (9/11/2012)
Lynn's method:
Elapsed Time (ms) 8276
ScottPletcher's first method:
Warning: Null value is eliminated by an aggregate or other SET operation.
Elapsed Time...
September 11, 2012 at 1:06 pm
Lynn Pettis (9/10/2012)
ScottPletcher (9/10/2012)
Lynn Pettis (9/10/2012)
ScottPletcher (9/10/2012)
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as...
September 10, 2012 at 5:09 pm
Lynn Pettis (9/10/2012)
ScottPletcher (9/10/2012)
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as I said, I...
September 10, 2012 at 4:28 pm
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as I said, I put that out...
September 10, 2012 at 4:18 pm
Lynn Pettis (9/7/2012)
September 10, 2012 at 1:25 pm
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
September 10, 2012 at 9:38 am
If you want precise control over shortening the results returned from a float column, there is always the ROUND() function.
If you want precise values, just use decimal to begin with....
September 7, 2012 at 4:17 pm
Lynn Pettis (9/7/2012)
September 7, 2012 at 4:11 pm
1. Columns are fields!
Technically they are not.
But in practice, many people refer to SQL columns as "fields", so you just have to accept that and move on.
September 7, 2012 at 3:55 pm
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
Viewing 15 posts - 7,216 through 7,230 (of 7,597 total)