I am trying to do something like this


CREATE PROC <mainProc>
CREATE TABLE #tmp(...)
subProcA
subProcB
<other code as needed>
go

Then, in a separate script, create the "sub" procedures:

CREATE TABLE #tmp (...)
CREATE PROC subProcA
<code which manipulates #tmp>
go
CREATE PROC subProcA
<code which manipulates #tmp>
go
DROP TABLE #tmp


But the problem is that when i try to create subProc with create #temp
as 1st command i get

"CREATE PROCEDURE must be the first command in a query batch"\


any ideas?

Shahzad Zafar wrote:

Separate batches. Run the create table #tmp, then run the
create proc.


Larry Coon
University of California