Sorry I dont understand...

Hi Jonathan

thank you very nuch for that. yes the JSON should have been passed in the parm declaration . I now realize that

I want to reseed the Value as Im then processing values using a loop , sequentially steping through the records

So i have something like this

SELECT

@VinCounter = MIN([ID]),

@VinMaxCounter = MAX([ID])

FROM

[#Items]

WHILE @VinCounter...

Hi Ratbak

Thank you very much for that. That works perfectly!

OK so the owner of the database is a user called 'Ci'

So does that mean if i wanted to refresh/update the database , then i should be using the user...

Hi

Its a managed DB instance

Hi guys

thanks for your responses on this

We were running the query on SSMS connected to Azure

Now we done some testing with our deployment. We deployed out of 'Net Rider using...

Hi guys

I figured this out . Need to create a user to create the database but you must specfy the following :

EXEC sp_addrolemember 'dbmanager', 'Ci';

EXEC sp_addrolemember 'loginmanager', 'Ci';

Hi marc

thanks for that. I guess the key to it, is when you see a JSON array that you treat it like this

ReadingsDto NVARCHAR(MAX) '$.ReadingsDto' AS JSON

And then use OpenJson...

Hi Drew

If there is more than more collection of Channels, ie more than 1 channel ID, how do i get that out ?

because at the moment when i run this...

Hi Drew

thansks vey much for that. I should have spotted it was 2 arrays of JSON

I made a slight alteration....removed the [0] from the end of the items array and

also...

No I havent added the variable to the SQLCMD variable collection in Database Properties

I am using jet brains rider. Do you know how I can add the variable into the...

sorry Phil.. I figured it out

/p:CreateNewDatabase=False

thanks Phil

I tried this in my arguments

/p:CreateNewDatabase:False

and i got the following error message:

'CreateNewDatabase:False' is not a valid argument for the 'Publish' action.

Thanks Phil. Yeah I saw that article and tried cmd.Parameters.Clear  but to no avail.