# Pass MultiQuery to MSSQL-PLUS
**URL:** https://discourse.nodered.org/t/pass-multiquery-to-mssql-plus/80454
**Category:** General
**Created:** [10 August 2023 08:04 UTC](https://discourse.nodered.org/t/pass-multiquery-to-mssql-plus/80454 "2023-08-10T08:04:41Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Mohamed\_1711](https://discourse.nodered.org/u/Mohamed_1711)
#### Post date: [10 August 2023 08:04 UTC](https://discourse.nodered.org/t/pass-multiquery-to-mssql-plus/80454/1 "2023-08-10T08:04:41Z")
I want to minimize my code :
I have function has two query and I want to pass this two query to one MSSQL-plus and get 2 output
from MSSQL-plus
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [10 August 2023 08:16 UTC](https://discourse.nodered.org/t/pass-multiquery-to-mssql-plus/80454/2 "2023-08-10T08:16:26Z")
You risk complicating your code by performing 2 queries in 1.
Are the queries related? Can you not simply return 2 rows based on a single query?
Alternatively, create a stored procedure that returns what you need?
Lastly, if you MUST, then add your 2 queries and set the `Output Type` to "driver" mode and see what you get in a debug node set to **Show Complete Message**
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [9 October 2023 08:16 UTC](https://discourse.nodered.org/t/pass-multiquery-to-mssql-plus/80454/3 "2023-10-09T08:16:48Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.