Loading...
ADO Error 2022-06-30 오전 7:01:43
User - 3.238.125.76 -
File : /Conference/ConferencePaperList.asp
Line : HYT00
Source : Microsoft OLE DB Provider for SQL Server
SQL : ;WITH C ( CS_NAME, CS_TYPE, CS_STATE) AS ( SELECT CS1.CS_NAME AS CS_NAME ,ISNULL(CC.CS_TYPE, '') AS CS_TYPE ,CASE ISNULL(CC.CS_NO, 0) WHEN 0 THEN 0 ELSE 1 END AS CS_STATE FROM TB_CONFERENCE_SECTION CS1 LEFT JOIN (SELECT CS_NO, CS_TYPE, CS_CLASS1, CS_CLASS2, ? AS Temp FROM TB_CONFERENCE_SUBMISSION WHERE C_NO=? AND CS_STATE>0 ) CC ON CC.CS_CLASS1=CS1.CS_NO WHERE CS1.CS_STATE>0 AND CS1.C_NO=? AND CS1.CS_SUB_NO=0 ) SELECT CS_NAME AS '발표분야', ISNULL([구두발표],0) as [구두발표],ISNULL([포스터발표],0) as [포스터발표],ISNULL([구두(15)],0) as [구두(15)],ISNULL([구두(40)],0) as [구두(40)] FROM C PIVOT ( SUM(CS_STATE) FOR CS_TYPE IN ( [구두발표],[포스터발표],[구두(15)],[구두(40)] ) ) AS PVT ORDER BY CS_NAME
Description : 쿼리 시간 제한이 만료되었습니다.
NativeError : 0
HelpFile :
HelpContext : 0