How can I use function with parameters in stored procedure sql-server : I need use dbo.function(@nb int) in stored procedure sql-server but I cant get the good result (table is empty):  
CREATE PROCEDURE dbo.procedure (@var int)  <br>
AS<br>
BEGIN<br>
DECLARE @Qry varchar(Max)<br>
SET <br>
'SELECT * FROM dbo.function(CONVERT(int,' + @var + '))'<br>
EXEC(@Qry)<br>
END<br>
...<br>
Thank you for help