# Importing data from MSSQL into a table in dashboard

**URL:** <https://discourse.nodered.org/t/importing-data-from-mssql-into-a-table-in-dashboard/71551>\
**Category:** Dashboard\
**Created:** [1 December 2022 12:59 UTC](https://discourse.nodered.org/t/importing-data-from-mssql-into-a-table-in-dashboard/71551 "2022-12-01T12:59:13Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [2 December 2022 11:47 UTC](https://discourse.nodered.org/t/importing-data-from-mssql-into-a-table-in-dashboard/71551/9 "2022-12-02T11:47:30Z")

</div>

> [@ALIEN](#):
>
> Hello friends, Finally I found the problem and I'd like to share my experince with you maybe it helps you later to save your time!

Glad you have things up and running once more.

> [@ALIEN](#):
>
> I noticed msg.payload has many subfolders which seems starnge,

More technically correct to say "`msg.payload` had multiple properties". NOTE: It is designed like that to permit the return of multiple queries and to access things like the count of rows affected, output parameter values, SQL Server system error messages etc, etc.

> [@ALIEN](#):
>
> I reinstalled node-red and imported the flows. I'm reading data directly from db(MSSQL) and Honestly I don't know how to fix this 🤒
> 
> ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/f/afac0bb001a30e31e7bc1058eebcc40088bb8ffd.png)

TBH, I mean no disrespect but that is a terrible way to do SQL. You risk SQL injection hacks. You should use the UI to make parameters.

Here are some examples that should help...

1. [Logging data in to MSSQL - #13 by Steve-Mcl](https://discourse.nodered.org/t/logging-data-in-to-mssql/67539/13)
2. [Extracting a value from an MS-SQL database - #6 by Steve-Mcl](https://discourse.nodered.org/t/extracting-a-value-from-an-ms-sql-database/61228/6)

---

_[View the full topic](https://discourse.nodered.org/t/importing-data-from-mssql-into-a-table-in-dashboard/71551)._