any sample of using this temp sproc?

i usually use dynamic query for defining same complex processes from multiple tables.

i wonder how to create temp sproc inside a procedure or it...

I prefer to use logging table as I need to collect events I need from multiple components or even packages and report it at scheduled time.

the problem for this script...