Default Values using Stored Procedure

[rmatthew]

I have output from a stored procedure that I desperately need to use as the default value of a column...

 

I cannot seem to write the sp as a UDF due to the use of a temporary table and 'exec sp_executesql as follows:

 

insert into #Foo exec sp_executesql @statement=@SQLQuery

 

Please help

[Puiu]

I think you could create a stored proc that would contain the code from the first stored proc where you get your value(s) and after that the insert statement...