# Stored Procedure Result

**URL:** <https://forum.radzen.com/t/stored-procedure-result/5981>\
**Category:** Angular\
**Created:** [December 10, 2020, 2:21pm UTC](https://forum.radzen.com/t/stored-procedure-result/5981 "2020-12-10T14:21:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![koblamic](https://forum.radzen.com/letter_avatar_proxy/v4/letter/k/c2a13f/32.png) [@koblamic](https://forum.radzen.com/u/koblamic)\
**Post date:** [December 10, 2020, 2:21pm UTC](https://forum.radzen.com/t/stored-procedure-result/5981/1 "2020-12-10T14:21:33Z")

</div>

Hello,  
I have application, where I use table result of stored procedure.  
This worked fine, until some of recent actualization and now I can use only numeric result of stored procedure.  
My setup is according to: [MS SQL Server (Angular)](https://www.radzen.com/documentation/ms-sql/#a-idstored-proceduresusing-stored-proceduresa)  
u

 ![Screenshot 2020-12-10 151758](https://forum.radzen.com/uploads/default/original/2X/9/9b516da87a0caeaf3ddf7dbef283ab0a07f3f28d.png)

in result is just number:

 ![Screenshot 2020-12-10 151920](https://forum.radzen.com/uploads/default/original/2X/3/3bed4ce33daed9ece035ae2dc83deed89414029d.png)

It works fine on the SQL:

 ![Screenshot 2020-12-10 152049](https://forum.radzen.com/uploads/default/original/2X/7/72425260e070dd138d7c7c2950b60a4db007d22a.png)

---

<div class="post-metadata">

**Author:** ![enchev](https://forum.radzen.com/user_avatar/forum.radzen.com/enchev/32/16_2.png) [@enchev](https://forum.radzen.com/u/enchev)\
**Post date:** [December 10, 2020, 2:26pm UTC](https://forum.radzen.com/t/stored-procedure-result/5981/2 "2020-12-10T14:26:11Z")

</div>

Numeric result indicates that the return type of the stored procedure is unknown.

---

<div class="post-metadata">

**Author:** ![koblamic](https://forum.radzen.com/letter_avatar_proxy/v4/letter/k/c2a13f/32.png) [@koblamic](https://forum.radzen.com/u/koblamic)\
**Post date:** [December 14, 2020, 9:40am UTC](https://forum.radzen.com/t/stored-procedure-result/5981/3 "2020-12-14T09:40:44Z")

</div>

Thank you for suggestion.  
Issue was caused by usage of temp tables. I follower [this blog](http://riteshkk2000.blogspot.com/2010/08/error-unknown-return-type-return-types.html?_sm_au_=iVV6Jk54srRpf5b6FLCNHKsHvc2jc) and replaced temptable with Declared table type.

CREATE TABLE #temp (Col A type, ...  
(doesn't work)  
versus  
DECLARE @temp TABLE (Col A type, ...  
(does work)