We are looking for a person
1) To take approximately 40 to 50 hrs at an agreed hourly rate,
2) Who has a lot of demonstratable experience with sql server stored procedures,
3) Including experienced with JSON functions available with SQL Server 2016
The requirement is to finalise a stored procedure currently in draft form that:
• Is called when an external system’s API requires a JSON object
• Calls on data stored in various tables in the database to create the required JSON object to return to the external API
• Uses a set of configuration tables in the database to specify the ordered series of dynamic sql statements that define the data stored in various tables that needs to be transformed into the required JSON object.