Good Morning all. Well it is just about finished, at least the database part. I want to thank everyone for all your help. I can now output a JSON file...

Hey everyone. Been buys working on the upcoming meet but I always try to get a little work coding each week. Now that I have the program working the way...

The bcp output seems to add them as if I open the json output in a web view and then compact it removing white spaces it import fine. The issue...

I have been racking the brain for a few weeks and ran into an issue I cannot figure out. There are extra white spaces in the JSON output that are...

Ok, I am almost done and really appreciate all the help everyone has done for me. The only issue I have not figured out is to check if a table...

I am having trouble getting the row data from multiple rows into a single row and only show one name.
USE meetscoreslive
DECLARE @test-2 varchar(8000)

select...

I added SQLCMD.Dispose() to the stop button which exits the sub. Is this correct.
    If StopSession = True Then
        SQLCMD.CommandText = "EXEC sp_configure 'xp_cmdshell',0
        RECONFIGURE

Ok, So I changed to open the database once and run my loop. Everything works although I am not sure I am disposing of the object. Is the exit sub...

So it looks like the " is the issue. I have tried different ways to change this " ' " etc but nothing works. Is there a way to have...