IF EXISTS( SELECT * FROM sysobjects WHERE name = \'T_a1040_ttt\' and TYPE = \'P\' )

DROP PROC T_a1040_ttt

go

CREATE PROC T_a1040_ttt

@user_id varchar(10)

AS

DELETE FROM

T_a1040

WHERE

user_id = @user_id

go

IF EXISTS( SELECT * FROM sysobjects WHERE name = \'T_a1030_ttt\' and TYPE = \'P\' )

DROP PROC T_a1030_delete

go

CREATE PROC T_a1030_ttt

@team_id varchar(10)

AS

EXEC T_a1040_ttt (select user_id from T_a1030 where team_id = @team_id)

DELETE FROM

T_a1030

WHERE

team_id = @team_id

go

*****(select user_id from T_a1030 where team_id = @team_id) 이부분에서 에러나거든여..

이부분을 배열로 받아서 처리 할방법이 있는지요..