# Different return values from ignition DB

**URL:** <https://forum.inductiveautomation.com/t/different-return-values-from-ignition-db/82816>\
**Category:** Ignition\
**Created:** [December 7, 2023, 12:58am UTC](https://forum.inductiveautomation.com/t/different-return-values-from-ignition-db/82816 "2023-12-07T00:58:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ignitionSL](https://avatars.discourse-cdn.com/v4/letter/i/9e8a1a/32.png) [@ignitionSL](https://forum.inductiveautomation.com/u/ignitionSL)\
**Post date:** [December 7, 2023, 12:58am UTC](https://forum.inductiveautomation.com/t/different-return-values-from-ignition-db/82816/1 "2023-12-07T00:58:44Z")

</div>

I ran a query to retrieve data from the same table in MSSQL and in ignition "Named queries" but the results were not the same. Therefore, I did a manual calculation using Excel and it was matched with MSSQL output.

> I wanted to get monthly averaged data from the table\<  
> Same as I ran the query per monthly(one by one) on Ignition DB and those values were matched with MSSQL output.  
> What could be the reason?

> Query
> 
> ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/e/5ea796651da44e7ac8cc176e74d054c7d1d27a8f.png)

> MSSQL Output  
> ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/1/313eaffbdf66cd048eb22724ae22e00f4d4e9386.png)

> Ignition DB Output
> 
> ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/7/671687397d52c670eaf50bdfcba9fca5264633c7.png)

---

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [December 7, 2023, 1:49am UTC](https://forum.inductiveautomation.com/t/different-return-values-from-ignition-db/82816/2 "2023-12-07T01:49:20Z")

</div>

It looks like we are dealing with three fields on which you want to perform some aggregate functions and miscellaneous functions. Ignition is not the best at handling complex SQL, so I would create a stored procedure that returns the dataset you are looking for. You might be able to create a function (?) to handle the formatting and conversion of the field `t_stamp` as well.

Your named query then would call the SP, passing any parameters as needed.

e.g. `EXEC usp_MyAveragePower :param1, :param2`

---

<div class="post-metadata">

**Author:** ![ignitionSL](https://avatars.discourse-cdn.com/v4/letter/i/9e8a1a/32.png) [@ignitionSL](https://forum.inductiveautomation.com/u/ignitionSL)\
**Post date:** [December 7, 2023, 2:42am UTC](https://forum.inductiveautomation.com/t/different-return-values-from-ignition-db/82816/3 "2023-12-07T02:42:31Z")

</div>

> [@mdemaris](#):
>
> stored procedure

I dont have any parameters to send. I need to get the average values of some data which is needed for another mathematical calculation.

---

<div class="post-metadata">

**Author:** ![ignitionSL](https://avatars.discourse-cdn.com/v4/letter/i/9e8a1a/32.png) [@ignitionSL](https://forum.inductiveautomation.com/u/ignitionSL)\
**Post date:** [December 7, 2023, 3:36am UTC](https://forum.inductiveautomation.com/t/different-return-values-from-ignition-db/82816/4 "2023-12-07T03:36:23Z")

</div>

I found a way to create a SP in the MSSQL and called it through Named Queries. It worked.  
Thank you very much

---

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [December 7, 2023, 4:50am UTC](https://forum.inductiveautomation.com/t/different-return-values-from-ignition-db/82816/5 "2023-12-07T04:50:12Z")

</div>

Sweet!