sql 2012 geometry to lat long in wgs84

I'm not an expert on the subject, but since the question is 'neglected' I'll try to help you out. I don't think SQL Server can do the conversion for you without you writing some code to do the conversion yourself. But then we need to determine what format is used for your coordinates. I think latitude and longitude are about degrees (-90 to 90 and -180 to +180), and your numbers look like a distance to me. So maybe they are easting and northing coordinates. My suggestion:
1. Determine the current coordinate system (if you don't know already).
2. Find a way to do the conversion, and test it manually to see if you get to the right location.
3. Find a way to do the conversion automatically (preferably within SQL Server).

If you don't know the answer to 1, you could ask in the 'GIS & GPS Programming' if anyone can help you out. Just mention a few of the coordinates and to what location they refer and someone might know the answer.

GEOMETRY is a coordinate in a plane. WGS84 is a coordinate in a sphere. WGS84 coordinates are also a latitude/longitude pair.

The problem is: What is the origin of your GEOMETRY values? When you don't know this, then it's a really hard task to get the projection right. Cause there are different transformations possible, which have a different precision.

Also, what does "The above coordinates place it an ocean." mean? Sounds like you need to provide an altitude in that web service.

Our coordinates are in northing/easting NAD83.  I can use OGR2OGR for the conversion.  I just thought maybe I was missing an easy way to do it inside of an SQL query.

I don't know an easy one, cause I haven't done conversion on that level.

My approach would be CLR-function doing this, but this requires some C# skills.