INTERSECT returns distinct shared rows, including shared NULL. Compare it with an equality join that preserves matching-pair multiplicity.
PI: Choose the Precision of a Circle Calculation
PI provides an approximate circle constant. This example keeps radius, circumference and two area calculations together to show when a chosen decimal conversion occurs.
geometry STIntersection: Return the Shared Shape
geometry STIntersection returns the shared shape rather than only an intersection flag. I inspect its type and emptiness alongside its area. A shared edge has zero area but still contains points.
SQL SERVER – Leading Zero to Number
Readers keep asking how to add a leading zero to a number. Here are my two earlier articles that pad a number with zeros for a fixed width display.
LAG IGNORE NULLS: Read the Previous Available Value
LAG IGNORE NULLS reads the previous non-NULL value within an ordered partition. These examples distinguish skipped rows, missing previous values and the supplied default.
Decimal Division: Inspect Precision Before the Final Cast
Decimal division derives its own precision and scale before your final cast. Compare wide and bounded inputs, then test rounding and valid numeric ranges.
SPACE: Keep Blank Text, Empty Text and NULL Distinct
SPACE builds a present blank string from a count. Keep empty text and NULL separate, and choose a measurement that retains supplied spaces.