날짜 상위 10개 가져와서 PIVOT 하기 DECLARE @DATE VARCHAR(1000) ,@DATETIME VARCHAR(1000) = '' , @QUERY VARCHAR(8000) DECLARE CURSOR1 CURSOR FOR SELECT DISTINCT TOP 10 CONVERT(DATE, [컬럼명]) FROM [테이블명] ORDER BY 1 DESC OPEN CURSOR1 FETCH NEXT FROM CURSOR1 INTO @DATE WHILE (@@FETCH_STATUS = 0) BEGIN SET @DATETIME = @DATETIME + '[' + @DATE + '],' FETCH NEXT FROM CURSOR1 INTO @DATE END CLOSE CURSOR1; DEALLOCATE C..