It would be awesome if coordinate transformations were built into SQL Server as they are in the PostGIS extension for Postgresql, but we can't be so lucky and this is awesome. Math always takes me a very long time to work through and I can't even imagine trying to tackle this. Someone in my office has utilized these formulas, so I can confirm that they do work!
I do have one question regarding these formulas; can it be assumed that they do not perform a datum transformation? In other words, you can use these formulas to transform coordinates in a Lambert conformal conic projections to it's CRS equivalent based on the GRS 80 Ellipsoid; but you would have to perform an additional transformation to get NAD27 (Clarke ellipsoid of 1866) or WGS 84 coordinates.
From what I've gathered, those datum transformations include even more complex math, but I could be interpreting things incorrectly. Thanks all!
