OS : Microsoft Windows 2000 Server / Advanced Server
SQL : Microsoft SQL Server 2000 Standard / Enterprise Edition
 
CREATE PROCEDURE [SP_TEST] AS
DECLARE @S1 NVARCHAR(255),@S2 NVARCHAR(255),@S3 NVARCHAR(255),@H NVARCHAR(255),@CNT INT
SET @S1=''
SET @S2=''
SET @S3=''
SET @H =''
SET @CNT =''
 
DECLARE @i INT
SET @i=1
 
DECLARE H_CUR CURSOR FOR
        SELECT COL1,COL2,COL3,COL4,COUNT(*) FROM YYY
        GROUP BY COL1,COL2,COL3,COL4
OPEN H_CUR
 
FETCH NEXT FROM H_CUR
        INTO @S1 ,@S2,@3,@H,@CNT 
SELECT @i,@S1 ,@S2,@3,@H
WHILE @@FETCH_STATUS=0
 
BEGIN
 
select COL1,COL2,COL3,COL4
into "서울_"+@S2+"_"+@H    <---------구문에러!
from TB 
WHERE 절...생략

FETCH NEXT FROM HDONG_CUR
        INTO @S1 ,@S2,@S3,@H,@CNT
SET @i = @i +1
SELECT @i,@S1,@S2,@S3,@H
 
END
 
CLOSE H_CUR
DEALLOCATE H_CUR 
GO
 
 
======================================================================================
YYY라는 테이블에서 조건별로 여러테이블을 생성하려는 PROC입니다.
테이블명을 변수로 정할수 있는지요?
into "서울_"+@S2+"_"+@H    <---------구문에러!
아시는분 조언부탁합니다.