Is there anything like?

@Result = EXEC sp_executesql @query

FETCH @Result

what I mean by that is that it will be cool if for example the "sp_executesql" instead of returning 1 or 0...

Remember we cannot create table inside a trigger on SQL 7 🙁 I do the same thing on other scenarios.

quote:

---

I meant something...

The client is using SQL 7, not support for UDF. I couldn't understand what you mean by

INSERT #temp_table ( <column list> )

sp_executesql @query

quote:

---