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...