UnearthedMedia Business & Technology

Prototype JS JSON String from TSQL view

Ran into a problem today that I found rather perplexing. I was pulling a json string that was generated from a storedprocedure in MsSQL 2005. One of the data columns being returned is a rounded decimal. If you execute the procedure in enterprise manager the value is correct something like 2.899. But when you look at the value in the JSON string it is coming out like 2.89736262673. Any ideas on what would be causing this? I haven’t found the cause of the problem yet, when I do I will post the solution here.