# MSSQL node imports "xxx... & ... " to "xxx... & ..."
**URL:** https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298
**Category:** General
**Created:** [17 June 2021 13:46 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298 "2021-06-17T13:46:52Z")
**Posts on this page:** 19
**Page:** 1
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 13:46 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/1 "2021-06-17T13:46:52Z")
Hi, MSQL node converts the `"&"` into `"&"` in a text field.
Here is the code in the MSSQL node:
> INSERT INTO [mrs\_Work]
> (PrjNo, ProjectName)
> VALUES (
> '{{{payload.PrjNo}}}',
> '{{{payload.ProjectName}}}'
> )
The inbound field `msg.payload.ProjectName` contains - for instance" `Integrated Plan & Schedule` - which then is stored in MSSQL as `Integrated Plan & Schedule`
How can I stop this conversion?
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [17 June 2021 13:52 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/2 "2021-06-17T13:52:08Z")
> [@IoTPlay](#):
>
> How can I stop this conversion
If you are using node-red-contrib-mssql-plus you can setup parameters in the UI & use them in the query...
```auto
INSERT INTO [mrs_Work]
(PrjNo, ProjectName)
VALUES (
@PrjNo,
@ProjectName
)
```
Better still, create a stored procedure & pass in parameters.
See the 1st screenshot in the [readme](https://flows.nodered.org/node/node-red-contrib-mssql-plus)
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 15:31 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/3 "2021-06-17T15:31:24Z")
Thank you! I will try it and report back. But I am using node `node-red-contrib-mssql-plus`.
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 16:28 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/4 "2021-06-17T16:28:35Z")
@Steve-Mcl - found my problem - mybad, I had a text string inserted with `'{{x}}'`, instead of `'{{x}}}'` in the node.
I am doing bulk'ish upload, 9300 records, did not know there were a beta solution - I came over the problem by batching in batches of 1000 - once you come ou of beta - I will use that rather. the 10,000 records are growing ...
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [17 June 2021 17:01 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/5 "2021-06-17T17:01:50Z")
Bulk insert is out of beta. Are you running v0.7.1?
Also, are the updates/inserts coming from free text? Using mustache is vulnerable to SQL injection hacks, you would be better off taking my advice about using parameters or stored procedure.
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 17:04 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/6 "2021-06-17T17:04:51Z")
Just upgraded to 0.7.1 - okay - did not know - let me refactor to use Bulk - right now I package an array of 1000 objects, then through them at a Spit note - feed them into the MSSQL node - one at a time, 2 seconds later the next 1000, and so on, but still getting niggling errors.
Let me see how to do that - and get rid of mustaches....
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 17:06 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/7 "2021-06-17T17:06:25Z")
> [@Steve-Mcl](#):
>
> are the updates/inserts coming from free text?
I download from our ERP into a spreadsheet, then use the Excel node to package it into a json Array, then point that to the 1000' breaker upper....
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [17 June 2021 17:08 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/8 "2021-06-17T17:08:28Z")
Yuk. What a kerfuffle.
Doesn't the ERP have a callable endpoint to avoid the whole excel part?
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 17:15 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/9 "2021-06-17T17:15:14Z")
Yes, it has, but IT does not want to let me in .... 8-( Still busy convincing them. IN the mean time - I must run a business.,.....
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [17 June 2021 17:16 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/10 "2021-06-17T17:16:49Z")
> [@IoTPlay](#):
>
> but IT does not want to let me in
I never understand that. If there is a http endpoint that has been coded correctly there is nothing your application can do to break the ERP.
Bloody IT. 😉
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 17:16 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/11 "2021-06-17T17:16:51Z")
Funny, examples not showing....
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [17 June 2021 17:17 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/12 "2021-06-17T17:17:33Z")
Where is it running? Have you refreshed browser after update?
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 17:18 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/13 "2021-06-17T17:18:06Z")
> [@Steve-Mcl](#):
>
> Bloody IT. 😉
Okay to download in a spreadsheet.... but not an end-point - as then I have access to the data. Wait until they find out I am pushing it into SQL .... from the spreadsheet.......
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 17:20 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/14 "2021-06-17T17:20:31Z")
> [@Steve-Mcl](#):
>
> Where is it running? Have you refreshed browser after update?
Closed browser now, re-opened, still not working. Safari in Mac. MS SQL on a NAS on Ubuntu - in Docker container.... Sweat solution .....
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [17 June 2021 17:25 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/15 "2021-06-17T17:25:12Z")
Most odd.
You can get examples [here](https://github.com/bestlong/node-red-contrib-mssql-plus/tree/master/examples)
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 17:27 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/16 "2021-06-17T17:27:01Z")
Now not sure how I will use BULK. Can I point a 10,000 msg.payload formatted in JSON, array with 10,000 objects at it too? Do not want to download a spreadsheet from ERP, then by hand convert that into CSV, with all the problems with commas in fields, and then point a CSV to the MSSQL node. But let me look into your examples to see if such solutions exists.
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [17 June 2021 17:28 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/17 "2021-06-17T17:28:48Z")
> [@IoTPlay](#):
>
> not sure how I will use BULK. Can I point a 10,000 msg.payload formatted in JSON, array with 10,000 objects at it
If formatted correctly yes.
Have a look at example.
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 17:33 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/18 "2021-06-17T17:33:00Z")
FLIPPEN HELL !!!! Ran the Bulk demo now, IT IS BLAZINGLY FAST !!!
---
### Author:  [@IoTPlay](https://discourse.nodered.org/u/IoTPlay)
#### Post date: [17 June 2021 20:48 UTC](https://discourse.nodered.org/t/mssql-node-imports-xxx-to-xxx-amp/47298/19 "2021-06-17T20:48:17Z")
Okay - got your BULK thing working, deleted reams and reams of work-around flows I had to build. Thank you Steve.