• 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 is just for ad hoc process in SSMS?