Pozdrav,
probaj sa:
INSERT INTO #tempTable EXEC spMyProc
sa tim da ako u proceduri spMyProc vec radis isto to (insert u temp table), nece raditi - javice ti gresku. Ja sam se napatio sa procedurom sp_help_jobs koja vraca recordset koji sadrzi informacije o job-ovima - ona radi insert u temp table tako da ne mozes njen rezultat insert-ovati u temp...Ali ima resenja i za to!
"The most likely way for the world to be destroyed, most experts agree, is by
accident. That's where we come in; we're computer professionals. We cause
accidents." - Nathaniel Borenstein