The current fee schedule is an ASP.NET Web application with a SQL Server back end.
Since the current infrastructure was based on SQL Server, I sought a way to convert the two SQL tables into JSON Objects so the current back end would not have to be changed. As it turns out, I found a good starting point on Stack Overflow. The only problem with this stored procedure was that it would not work properly if there were single quotes in the results, or if the column names had spaces.
I was able to modify the stored proc to allow for these changes as well as a few others, such as accounting for NULL values. The modified SP is posted below for your reading pleasure!
I'm a developer with more than fifteen years' experience as a programmer and information technology generalist with various Fortune 500 companies. Member of Google Glass Explorers program. Expertise includes Web, database, and application development.
My blog is a labor of love. I hope to be able to continue to maintain this site and write articles that make your jobs easier! To help support this site, feel free to buy me a cup of Java with whatever amount you like.