When I run this code in visual studio I get an expected end of statement on the SELECT part of the bcp utility. But If I run the same code...

So here is the code to get it to work about 90%. It creates the json file but with all the records and so not sorted by AgeGrp.
[code...

Is there a way to execute a query from another query. I see that you have subqueries but I am not interested in returning the results. Instead of repeating multiple...

I am using this code to try to output the query to .json. It crerate the file but errors on something.

SELECT * FROM dbo.ResultsLvl3

I am getting so close. I am using the cursor function to loop through the age groups to output the different results. Everything works using the print function and the...

Here is my work around. The only issue is the print statement does not translate to VS. I am not sure how to get this to work. So basically you...

I am getting this error. Also I wanted to check for the table and then ask the user if they want to delete it or not. That is why I...

I have now started to insert the working queries into VS 2017. It is going well but I am having a hard time with one aspect. I am not sure...

NA