ishaan99 (12/8/2008)

---

Has anyone tried calling a stored procdure from a user defined function. I have a procedure as Proc_XXX with 7 parameters if i do exec Proc_XXX(null,null,null,null,null,'1/1/1998','1/1/2007') i am getting the result set. Is it possible to have the same results when calling thru a function .

call Proc_XXX(null,null,null,null,null,'1/1/1998','1/1/2007')

any help on this will be greatly appreciated. TIA

Yasemin Örnek (9/19/2012)

---

Hi , I want to ask a question ,
Is it possible executing dynamic sql and store values in a temp table with WITH clause like below code?

DECLARE @sqltxt nvarchar(max) ;

SET @sqltxt='select col112,col221 from sometable';

WITH temptable (col1,col2) as
(exec sp_executesql @sqltxt )
select * from temptable

Or how can I achive this task with sql?
Thanks.

DECLARE @sqltxt nvarchar(max) ;

SET @sqltxt='INSERT INTO temptable (col1,col2) select col112,col221 from sometable';

exec sp_executesql @sqltxt 

select * from temptable