Hey guys

Thanks a lot for your  posts on this.

One option im looking at is to use bash scripting to call bcp.

I think i can connect my docker container to bash....

Hi Phil

That works for me.. thank you very much for that

Hi Ant

The data is coming from a website with text entry , so people can enter 84.99 or 85...

Yes I am thinking of changing the datatype to Decimal but would...

Here's the updated post that actually takes advantage of JSON.  No need for TRIM() or STRING_SPLIT() functions because the source is in a proper JSON ARRAY format.  Again, this...

OK guys I have found the solution to do this.. and now I will explain in steps what to do:

1. Download and run the 64 bit versiond of the Microsoft...

I downloaded and ran ACE - 64 bit version but now get the following error when trying to browse a linked server to MS Access that i have created

This returns your desired results, but is it what you want?

DECLARE @SQL1 NVARCHAR(MAX)
    = N'SELECT ri.Serial_Number
      ,UnitType =...

Only thing I can see is that it is waiting for log memory, the temp/table var don't require log memory.

But it is constant physical table under performs on the...

On what in Azure? Azure SQL Database? If so what size? Is it DTU? Is it vCore? ...

Ok thats interesting. But are you able to run this on Azure?

Ok im going to expand on this.

Ive got to loop through this table and build set of Merge statements.

Currently I am using Loop based logic to extract and execute a...

I want to get to the last record

but i thinik ive found...

Since you're only doing INSERT and not UPDATE, you don't need MERGE.

I really can't follow the different tables you have since there's only one source table for all the...

• This reply was modified 1 year, 7 months ago by  Weegee71.

Can be done your logic is just a little off.

The "ParamDefinition" must be a continuous string of all params for the dynamic SQL

DECLARE @t [dbo].[ChannelReadingType];
DECLARE @ChannelReadingTableName...

I dont want to use a temp table because we are...