# SQL procedure outputs columns in totally different order

**URL:** <https://discourse.nodered.org/t/sql-procedure-outputs-columns-in-totally-different-order/73540>\
**Category:** General\
**Created:** [11 January 2023 14:51 UTC](https://discourse.nodered.org/t/sql-procedure-outputs-columns-in-totally-different-order/73540 "2023-01-11T14:51:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![milner236](https://avatars.discourse-cdn.com/v4/letter/m/a4c791/32.png) [@milner236](https://discourse.nodered.org/u/milner236)\
**Post date:** [11 January 2023 14:51 UTC](https://discourse.nodered.org/t/sql-procedure-outputs-columns-in-totally-different-order/73540/1 "2023-01-11T14:51:09Z")

</div>

Hello everyone,  
I have a procedure in SQL that outputs a table that includes columns of different types.  
When I run it, I receive a perfectly normal output.  
However, when I run the same exact procedure with node-red using the MSSQL pallet, the order of the columns is totally different.  
Why is that?

---

<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:** [11 January 2023 15:18 UTC](https://discourse.nodered.org/t/sql-procedure-outputs-columns-in-totally-different-order/73540/2 "2023-01-11T15:18:10Z")

</div>

Which actual mssql contrib node are you using?

Do you specify the columns in the SQL (or use a `*`)?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [12 March 2023 15:19 UTC](https://discourse.nodered.org/t/sql-procedure-outputs-columns-in-totally-different-order/73540/3 "2023-03-12T15:19:04Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.