개체 이름 'TB_HEALTHY_EVENT'이(가) 잘못되었습니다.
Microsoft OLE DB Provider for SQL Server
-- getEventList SELECT * FROM ( SELECT * ,COUNT(HE.EVENT_SEQ) OVER() AS TOTAL_COUNT ,ROW_NUMBER() OVER (ORDER BY HE.EVENT_SEQ DESC) AS RNUM FROM( SELECT HE.* , (SELECT COUNT(RECOMM_SEQ) FROM TB_HEALTHY_EVENT_RECOMM HER WHERE HER.EVENT_SEQ = HE.EVENT_SEQ ) AS RECOMM_CNT FROM TB_HEALTHY_EVENT AS HE) AS HE WHERE HE.STATUS = 'Y' ) AS TBL WHERE RNUM BETWEEN ((1-1)*9)+1 AND 1*9