Robert Cannistraci

<div>
My bad. It was a proc. I changed it to a function and all is well. Thanks for the help
</div>


<div>
<div class="content wysiwyg-content">
A function returning a string does so correctly when calling it as stand-alone correctly returns:<br />
<br />
<b>EXEC EmployeeDietaryRestriction<wbr />_SELECT_Di<wbr />etPerEmpID<wbr /> 184</b><br />
<br />
Returns: 'Gluten-Free,Vegetrian,Veg<wbr />an,' &lt;&nbsp;correct<br />
<br />
However, when called in an SP it returns a incorrect value:<br />
<br />
<b>EXEC @DietaryRestriction = EmployeeDietaryRestriction<wbr />_SELECT_Di<wbr />etPerEmpID<wbr /> @EmployeeID </b> --184<br />
<br />
It Returns: '0' which is incorrect. It looks like a result code.<br />
<br />
Why doesn't it work called from an SP? What am I missing here? Thank you for any help.
</div>
</div>


A function returning a string does so correctly when calling it as stand-alone correctly returns:

EXEC EmployeeDietaryRestriction_SELECT_DietPerEmpID 184

Returns: 'Gluten-Free,Vegetrian,Vegan,' < correct

However, when called in an SP it returns a incorrect value:

EXEC @DietaryRestriction = EmployeeDietaryRestriction_SELECT_DietPerEmpID @EmployeeID  --184

It Returns: '0' which is incorrect. It looks like a result code.

Why doesn't it work called from an SP? What am I missing here? Thank you for any help.

My bad. It was a proc. I changed it to a function and all is well. Thanks for the help

Function is Correct, but Returns Incorrect Value when Called by SP

A function returning a string does so correctly when calling it as stand-alone correctly returns:

EXEC EmployeeDietaryRestriction_SELECT_DietPerEmpID 184

Returns: &#39;Gluten-Free,Vegetrian,Vegan,&#39; &lt; correct

However, when called in an SP it returns a incorrect value:

EXEC @DietaryRestriction = EmployeeDietaryRestriction_SELECT_DietPerEmpID @EmployeeID  --184

It Returns: &#39;0&#39; which is incorrect. It looks like a result code.

Why doesn&#39;t it work called from an SP? What am I missing here? Thank you for any help.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.