UPDATE TDAŠ¨’è‰È–ÚM SET Š—L‰ïŽÐCD = '' WHERE Š—L‰ïŽÐCD IS NULL UPDATE TDAŠ¨’è‰È–ÚM SET ƒf[ƒ^‹æ•ª = '1' WHERE ƒf[ƒ^‹æ•ª = 'D' if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TC4‰‰K‹–‰ÂŠw¶ƒOƒ‹[ƒvM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TC4‰‰K‹–‰ÂŠw¶ƒOƒ‹[ƒvM end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TDA•ñ‘‘Ž®M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TDA•ñ‘‘Ž®M end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TGA“üoŒÉ–¾×TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TGA“üoŒÉ–¾×TRN end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TGB‹âsŒûÀ“üo‹àTRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TGB‹âsŒûÀ“üo‹àTRN end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK“`•[–¾×F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK“`•[–¾×F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK’ •ë_Žd–ó“ú‹L’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK’ •ë_Žd–ó“ú‹L’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK’ •ë_Žd–óWŒv•\F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK’ •ë_Žd–óWŒv•\F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK’ •ë_”ªŒ…¸ŽZ•\F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK’ •ë_”ªŒ…¸ŽZ•\F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK’ •ë_‡ŒvŽc‚ŽŽŽZ•\F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK’ •ë_‡ŒvŽc‚ŽŽŽZ•\F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK’ •ë_‘¹‰vŒvŽZ‘F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK’ •ë_‘¹‰vŒvŽZ‘F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK’ •ë_‘Š¨’茳’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK’ •ë_‘Š¨’茳’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK’ •ë_‘ÝŽØ‘ÎÆ•\F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK’ •ë_‘ÝŽØ‘ÎÆ•\F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK•â••ë_Žd“ü’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK•â••ë_Žd“ü’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK•â••ë_ŽóŽæŽèŒ`‹L“ü’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK•â••ë_ŽóŽæŽèŒ`‹L“ü’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK•â••ë_¤•i—L‚’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK•â••ë_¤•i—L‚’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK•â••ë_”„ã’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK•â••ë_”„ã’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK•â••ë_”„Š|‹àŒ³’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK•â••ë_”„Š|‹àŒ³’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK•â••ë_“–À—a‹ào”[’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK•â••ë_“–À—a‹ào”[’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK•â••ë_Žx•¥ŽèŒ`‹L“ü’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK•â••ë_Žx•¥ŽèŒ`‹L“ü’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK•â••ë_Œ»‹ào”[’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK•â••ë_Œ»‹ào”[’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TSK•â••ë_”ƒŠ|‹àŒ³’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TSK•â••ë_”ƒŠ|‹àŒ³’ F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YTMP_TTL‡•¹Žc‚F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin DROP TABLE dbo.YTMP_TTL‡•¹Žc‚F end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TC1ƒVƒXƒeƒ€M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TC1ƒVƒXƒeƒ€M]') AND id = object_id(N'[dbo].[PK_TC1ƒVƒXƒeƒ€M]')) begin ALTER TABLE [dbo].[WORK_TC1ƒVƒXƒeƒ€M] DROP PK_TC1ƒVƒXƒeƒ€M end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TC2‰‰KM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TC2‰‰KM]') AND id = object_id(N'[dbo].[PK_TC2‰‰KM]')) begin ALTER TABLE [dbo].[WORK_TC2‰‰KM] DROP PK_TC2‰‰KM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TC3Šw¶ƒOƒ‹[ƒvM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TC3Šw¶ƒOƒ‹[ƒvM]') AND id = object_id(N'[dbo].[PK_TC3Šw¶ƒOƒ‹[ƒvM]')) begin ALTER TABLE [dbo].[WORK_TC3Šw¶ƒOƒ‹[ƒvM] DROP PK_TC3Šw¶ƒOƒ‹[ƒvM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TC4‰‰K‹–‰ÂŠw¶ƒOƒ‹[ƒvM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TC4‰‰K‹–‰ÂŠw¶ƒOƒ‹[ƒvM]') AND id = object_id(N'[dbo].[PK_TC4‰‰K‹–‰ÂŠw¶ƒOƒ‹[ƒvM]')) begin ALTER TABLE [dbo].[WORK_TC4‰‰K‹–‰ÂŠw¶ƒOƒ‹[ƒvM] DROP PK_TC4‰‰K‹–‰ÂŠw¶ƒOƒ‹[ƒvM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TC5Šw¶M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TC5Šw¶M]') AND id = object_id(N'[dbo].[PK_TC5Šw¶M]')) begin ALTER TABLE [dbo].[WORK_TC5Šw¶M] DROP PK_TC5Šw¶M end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TC6‰‰K—š—ðM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TC6‰‰K—š—ðM]') AND id = object_id(N'[dbo].[PK_TC6‰‰K—š—ðM]')) begin ALTER TABLE [dbo].[WORK_TC6‰‰K—š—ðM] DROP PK_TC6‰‰K—š—ðM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TC9‹æ•ªM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TC9‹æ•ªM]') AND id = object_id(N'[dbo].[PK_TC9‹æ•ªM]')) begin ALTER TABLE [dbo].[WORK_TC9‹æ•ªM] DROP PK_TC9‹æ•ªM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TC9–¼ŽhƒfƒUƒCƒ“M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TC9–¼ŽhƒfƒUƒCƒ“M]') AND id = object_id(N'[dbo].[PK_TC9–¼ŽhƒfƒUƒCƒ“M]')) begin ALTER TABLE [dbo].[WORK_TC9–¼ŽhƒfƒUƒCƒ“M] DROP PK_TC9–¼ŽhƒfƒUƒCƒ“M end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TC9•¶‘Ží—ÞM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TC9•¶‘Ží—ÞM]') AND id = object_id(N'[dbo].[PK_TC9•¶‘Ží—ÞM]')) begin ALTER TABLE [dbo].[WORK_TC9•¶‘Ží—ÞM] DROP PK_TC9•¶‘Ží—ÞM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TDA‰ïŽÐM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TDA‰ïŽÐM]') AND id = object_id(N'[dbo].[PK_TDA‰ïŽÐM]')) begin ALTER TABLE [dbo].[WORK_TDA‰ïŽÐM] DROP PK_TDA‰ïŽÐM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TDAŠ¨’è‰È–ÚM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TDAŠ¨’è‰È–ÚM]') AND id = object_id(N'[dbo].[PK_TDAŠ¨’è‰È–ÚM]')) begin ALTER TABLE [dbo].[WORK_TDAŠ¨’è‰È–ÚM] DROP PK_TDAŠ¨’è‰È–ÚM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TDA¤•iM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TDA¤•iM]') AND id = object_id(N'[dbo].[PK_TDA¤•iM]')) begin ALTER TABLE [dbo].[WORK_TDA¤•iM] DROP PK_TDA¤•iM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TDA•ñ‘‘Ž®M]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TDA•ñ‘‘Ž®M]') AND id = object_id(N'[dbo].[PK_TDA•ñ‘‘Ž®M]')) begin ALTER TABLE [dbo].[WORK_TDA•ñ‘‘Ž®M] DROP PK_TDA•ñ‘‘Ž®M end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TDAŽsêM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TDAŽsêM]') AND id = object_id(N'[dbo].[PK_TDAŽsêM]')) begin ALTER TABLE [dbo].[WORK_TDAŽsêM] DROP PK_TDAŽsêM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TGA“üoŒÉTRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TGA“üoŒÉTRN]') AND id = object_id(N'[dbo].[PK_TGA“üoŒÉTRN]')) begin ALTER TABLE [dbo].[WORK_TGA“üoŒÉTRN] DROP PK_TGA“üoŒÉTRN end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TGA“üoŒÉ–¾×TRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TGA“üoŒÉ–¾×TRN]') AND id = object_id(N'[dbo].[PK_TGA“üoŒÉ–¾×TRN]')) begin ALTER TABLE [dbo].[WORK_TGA“üoŒÉ–¾×TRN] DROP PK_TGA“üoŒÉ–¾×TRN end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TGAŽèŒ`F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TGAŽèŒ`F]') AND id = object_id(N'[dbo].[PK_TGAŽèŒ`F]')) begin ALTER TABLE [dbo].[WORK_TGAŽèŒ`F] DROP PK_TGAŽèŒ`F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TGB‹âsŒûÀF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TGB‹âsŒûÀF]') AND id = object_id(N'[dbo].[PK_TGB‹âsŒûÀF]')) begin ALTER TABLE [dbo].[WORK_TGB‹âsŒûÀF] DROP PK_TGB‹âsŒûÀF end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TGB‹âsŒûÀ“üo‹àTRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TGB‹âsŒûÀ“üo‹àTRN]') AND id = object_id(N'[dbo].[PK_TGB‹âsŒûÀ“üo‹àTRN]')) begin ALTER TABLE [dbo].[WORK_TGB‹âsŒûÀ“üo‹àTRN] DROP PK_TGB‹âsŒûÀ“üo‹àTRN end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TGC•ÛŒ¯Œ_–ñF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TGC•ÛŒ¯Œ_–ñF]') AND id = object_id(N'[dbo].[PK_TGC•ÛŒ¯Œ_–ñF]')) begin ALTER TABLE [dbo].[WORK_TGC•ÛŒ¯Œ_–ñF] DROP PK_TGC•ÛŒ¯Œ_–ñF end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TGCoŒÉF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TGCoŒÉF]') AND id = object_id(N'[dbo].[PK_TGCoŒÉF]')) begin ALTER TABLE [dbo].[WORK_TGCoŒÉF] DROP PK_TGCoŒÉF end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TGCŠñ‘õŽÒ‘ä’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TGCŠñ‘õŽÒ‘ä’ F]') AND id = object_id(N'[dbo].[PK_TGCŠñ‘õŽÒ‘ä’ F]')) begin ALTER TABLE [dbo].[WORK_TGCŠñ‘õŽÒ‘ä’ F] DROP PK_TGCŠñ‘õŽÒ‘ä’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TGC‰^‘—Œ_–ñF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TGC‰^‘—Œ_–ñF]') AND id = object_id(N'[dbo].[PK_TGC‰^‘—Œ_–ñF]')) begin ALTER TABLE [dbo].[WORK_TGC‰^‘—Œ_–ñF] DROP PK_TGC‰^‘—Œ_–ñF end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TGKŒ»‹à“üo‹àTRN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TGKŒ»‹à“üo‹àTRN]') AND id = object_id(N'[dbo].[PK_TGKŒ»‹à“üo‹àTRN]')) begin ALTER TABLE [dbo].[WORK_TGKŒ»‹à“üo‹àTRN] DROP PK_TGKŒ»‹à“üo‹àTRN end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSAŽd“ü”„ã‘—ÞF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSAŽd“ü”„ã‘—ÞF]') AND id = object_id(N'[dbo].[PK_TSAŽd“ü”„ã‘—ÞF]')) begin ALTER TABLE [dbo].[WORK_TSAŽd“ü”„ã‘—ÞF] DROP PK_TSAŽd“ü”„ã‘—ÞF end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSAŽd“ü”„ã‘—Þ–¾×F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSAŽd“ü”„ã‘—Þ–¾×F]') AND id = object_id(N'[dbo].[PK_TSAŽd“ü”„ã‘—Þ–¾×F]')) begin ALTER TABLE [dbo].[WORK_TSAŽd“ü”„ã‘—Þ–¾×F] DROP PK_TSAŽd“ü”„ã‘—Þ–¾×F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSB‹âsŽæˆø\ž‘—ÞF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSB‹âsŽæˆø\ž‘—ÞF]') AND id = object_id(N'[dbo].[PK_TSB‹âsŽæˆø\ž‘—ÞF]')) begin ALTER TABLE [dbo].[WORK_TSB‹âsŽæˆø\ž‘—ÞF] DROP PK_TSB‹âsŽæˆø\ž‘—ÞF end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSC‰^‘—‘—ÞF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSC‰^‘—‘—ÞF]') AND id = object_id(N'[dbo].[PK_TSC‰^‘—‘—ÞF]')) begin ALTER TABLE [dbo].[WORK_TSC‰^‘—‘—ÞF] DROP PK_TSC‰^‘—‘—ÞF end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSC‰^‘—‘—Þ–¾×F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSC‰^‘—‘—Þ–¾×F]') AND id = object_id(N'[dbo].[PK_TSC‰^‘—‘—Þ–¾×F]')) begin ALTER TABLE [dbo].[WORK_TSC‰^‘—‘—Þ–¾×F] DROP PK_TSC‰^‘—‘—Þ–¾×F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSC‰^‘—”ï¿‹‘F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSC‰^‘—”ï¿‹‘F]') AND id = object_id(N'[dbo].[PK_TSC‰^‘—”ï¿‹‘F]')) begin ALTER TABLE [dbo].[WORK_TSC‰^‘—”ï¿‹‘F] DROP PK_TSC‰^‘—”ï¿‹‘F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSC‰^‘—”ï¿‹‘Žè“®F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSC‰^‘—”ï¿‹‘Žè“®F]') AND id = object_id(N'[dbo].[PK_TSC‰^‘—”ï¿‹‘Žè“®F]')) begin ALTER TABLE [dbo].[WORK_TSC‰^‘—”ï¿‹‘Žè“®F] DROP PK_TSC‰^‘—”ï¿‹‘Žè“®F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSC‰^‘—”ï¿‹‘Žè“®–¾×F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSC‰^‘—”ï¿‹‘Žè“®–¾×F]') AND id = object_id(N'[dbo].[PK_TSC‰^‘—”ï¿‹‘Žè“®–¾×F]')) begin ALTER TABLE [dbo].[WORK_TSC‰^‘—”ï¿‹‘Žè“®–¾×F] DROP PK_TSC‰^‘—”ï¿‹‘Žè“®–¾×F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK“`•[F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK“`•[F]') AND id = object_id(N'[dbo].[PK_TSK“`•[F]')) begin ALTER TABLE [dbo].[WORK_TSK“`•[F] DROP PK_TSK“`•[F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK“`•[Žd“ü”„ã–¾×F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK“`•[Žd“ü”„ã–¾×F]') AND id = object_id(N'[dbo].[PK_TSK“`•[Žd“ü”„ã–¾×F]')) begin ALTER TABLE [dbo].[WORK_TSK“`•[Žd“ü”„ã–¾×F] DROP PK_TSK“`•[Žd“ü”„ã–¾×F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK“`•[–¾×F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK“`•[–¾×F]') AND id = object_id(N'[dbo].[PK_TSK“`•[–¾×F]')) begin ALTER TABLE [dbo].[WORK_TSK“`•[–¾×F] DROP PK_TSK“`•[–¾×F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK’ •ë_Žd–ó“ú‹L’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK’ •ë_Žd–ó“ú‹L’ F]') AND id = object_id(N'[dbo].[PK_TSK’ •ë_Žd–ó“ú‹L’ F]')) begin ALTER TABLE [dbo].[WORK_TSK’ •ë_Žd–ó“ú‹L’ F] DROP PK_TSK’ •ë_Žd–ó“ú‹L’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK’ •ë_Žd–óWŒv•\F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK’ •ë_Žd–óWŒv•\F]') AND id = object_id(N'[dbo].[PK_TSK’ •ë_Žd–óWŒv•\F]')) begin ALTER TABLE [dbo].[WORK_TSK’ •ë_Žd–óWŒv•\F] DROP PK_TSK’ •ë_Žd–óWŒv•\F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK’ •ë_”ªŒ…¸ŽZ•\F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK’ •ë_”ªŒ…¸ŽZ•\F]') AND id = object_id(N'[dbo].[PK_TSK’ •ë_”ªŒ…¸ŽZ•\F]')) begin ALTER TABLE [dbo].[WORK_TSK’ •ë_”ªŒ…¸ŽZ•\F] DROP PK_TSK’ •ë_”ªŒ…¸ŽZ•\F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK’ •ë_‡ŒvŽc‚ŽŽŽZ•\F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK’ •ë_‡ŒvŽc‚ŽŽŽZ•\F]') AND id = object_id(N'[dbo].[PK_TSK’ •ë_‡ŒvŽc‚ŽŽŽZ•\F]')) begin ALTER TABLE [dbo].[WORK_TSK’ •ë_‡ŒvŽc‚ŽŽŽZ•\F] DROP PK_TSK’ •ë_‡ŒvŽc‚ŽŽŽZ•\F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK’ •ë_‘¹‰vŒvŽZ‘F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK’ •ë_‘¹‰vŒvŽZ‘F]') AND id = object_id(N'[dbo].[PK_TSK’ •ë_‘¹‰vŒvŽZ‘F]')) begin ALTER TABLE [dbo].[WORK_TSK’ •ë_‘¹‰vŒvŽZ‘F] DROP PK_TSK’ •ë_‘¹‰vŒvŽZ‘F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK’ •ë_‘Š¨’茳’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK’ •ë_‘Š¨’茳’ F]') AND id = object_id(N'[dbo].[PK_TSK’ •ë_‘Š¨’茳’ F]')) begin ALTER TABLE [dbo].[WORK_TSK’ •ë_‘Š¨’茳’ F] DROP PK_TSK’ •ë_‘Š¨’茳’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK’ •ë_‘ÝŽØ‘ÎÆ•\F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK’ •ë_‘ÝŽØ‘ÎÆ•\F]') AND id = object_id(N'[dbo].[PK_TSK’ •ë_‘ÝŽØ‘ÎÆ•\F]')) begin ALTER TABLE [dbo].[WORK_TSK’ •ë_‘ÝŽØ‘ÎÆ•\F] DROP PK_TSK’ •ë_‘ÝŽØ‘ÎÆ•\F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK•â••ë_Žd“ü’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK•â••ë_Žd“ü’ F]') AND id = object_id(N'[dbo].[PK_TSK•â••ë_Žd“ü’ F]')) begin ALTER TABLE [dbo].[WORK_TSK•â••ë_Žd“ü’ F] DROP PK_TSK•â••ë_Žd“ü’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK•â••ë_ŽóŽæŽèŒ`‹L“ü’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK•â••ë_ŽóŽæŽèŒ`‹L“ü’ F]') AND id = object_id(N'[dbo].[PK_TSK•â••ë_ŽóŽæŽèŒ`‹L“ü’ F]')) begin ALTER TABLE [dbo].[WORK_TSK•â••ë_ŽóŽæŽèŒ`‹L“ü’ F] DROP PK_TSK•â••ë_ŽóŽæŽèŒ`‹L“ü’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK•â••ë_¤•i—L‚’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK•â••ë_¤•i—L‚’ F]') AND id = object_id(N'[dbo].[PK_TSK•â••ë_¤•i—L‚’ F]')) begin ALTER TABLE [dbo].[WORK_TSK•â••ë_¤•i—L‚’ F] DROP PK_TSK•â••ë_¤•i—L‚’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK•â••ë_”„ã’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK•â••ë_”„ã’ F]') AND id = object_id(N'[dbo].[PK_TSK•â••ë_”„ã’ F]')) begin ALTER TABLE [dbo].[WORK_TSK•â••ë_”„ã’ F] DROP PK_TSK•â••ë_”„ã’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK•â••ë_”„Š|‹àŒ³’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK•â••ë_”„Š|‹àŒ³’ F]') AND id = object_id(N'[dbo].[PK_TSK•â••ë_”„Š|‹àŒ³’ F]')) begin ALTER TABLE [dbo].[WORK_TSK•â••ë_”„Š|‹àŒ³’ F] DROP PK_TSK•â••ë_”„Š|‹àŒ³’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK•â••ë_“–À—a‹ào”[’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK•â••ë_“–À—a‹ào”[’ F]') AND id = object_id(N'[dbo].[PK_TSK•â••ë_“–À—a‹ào”[’ F]')) begin ALTER TABLE [dbo].[WORK_TSK•â••ë_“–À—a‹ào”[’ F] DROP PK_TSK•â••ë_“–À—a‹ào”[’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK•â••ë_Žx•¥ŽèŒ`‹L“ü’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK•â••ë_Žx•¥ŽèŒ`‹L“ü’ F]') AND id = object_id(N'[dbo].[PK_TSK•â••ë_Žx•¥ŽèŒ`‹L“ü’ F]')) begin ALTER TABLE [dbo].[WORK_TSK•â••ë_Žx•¥ŽèŒ`‹L“ü’ F] DROP PK_TSK•â••ë_Žx•¥ŽèŒ`‹L“ü’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK•â••ë_Œ»‹ào”[’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK•â••ë_Œ»‹ào”[’ F]') AND id = object_id(N'[dbo].[PK_TSK•â••ë_Œ»‹ào”[’ F]')) begin ALTER TABLE [dbo].[WORK_TSK•â••ë_Œ»‹ào”[’ F] DROP PK_TSK•â••ë_Œ»‹ào”[’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TSK•â••ë_”ƒŠ|‹àŒ³’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TSK•â••ë_”ƒŠ|‹àŒ³’ F]') AND id = object_id(N'[dbo].[PK_TSK•â••ë_”ƒŠ|‹àŒ³’ F]')) begin ALTER TABLE [dbo].[WORK_TSK•â••ë_”ƒŠ|‹àŒ³’ F] DROP PK_TSK•â••ë_”ƒŠ|‹àŒ³’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TTA‘¹‰vŒv‰æF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TTA‘¹‰vŒv‰æF]') AND id = object_id(N'[dbo].[PK_TTA‘¹‰vŒv‰æF]')) begin ALTER TABLE [dbo].[WORK_TTA‘¹‰vŒv‰æF] DROP PK_TTA‘¹‰vŒv‰æF end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TTAŽÐˆõ‘ä’ F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TTAŽÐˆõ‘ä’ F]') AND id = object_id(N'[dbo].[PK_TTAŽÐˆõ‘ä’ F]')) begin ALTER TABLE [dbo].[WORK_TTAŽÐˆõ‘ä’ F] DROP PK_TTAŽÐˆõ‘ä’ F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TTK“E—vM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TTK“E—vM]') AND id = object_id(N'[dbo].[PK_TTK“E—vM]')) begin ALTER TABLE [dbo].[WORK_TTK“E—vM] DROP PK_TTK“E—vM end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TTK‹L’ ƒ`ƒFƒbƒNF]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TTK‹L’ ƒ`ƒFƒbƒNF]') AND id = object_id(N'[dbo].[PK_TTK‹L’ ƒ`ƒFƒbƒNF]')) begin ALTER TABLE [dbo].[WORK_TTK‹L’ ƒ`ƒFƒbƒNF] DROP PK_TTK‹L’ ƒ`ƒFƒbƒNF end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TTL‡•¹Žc‚F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TTL‡•¹Žc‚F]') AND id = object_id(N'[dbo].[PK_TTL‡•¹Žc‚F]')) begin ALTER TABLE [dbo].[WORK_TTL‡•¹Žc‚F] DROP PK_TTL‡•¹Žc‚F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TTM–¼Žhƒf[ƒ^2F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TTM–¼Žhƒf[ƒ^2F]') AND id = object_id(N'[dbo].[PK_TTM–¼Žhƒf[ƒ^2F]')) begin ALTER TABLE [dbo].[WORK_TTM–¼Žhƒf[ƒ^2F] DROP PK_TTM–¼Žhƒf[ƒ^2F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TTM–¼Žhƒf[ƒ^F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TTM–¼Žhƒf[ƒ^F]') AND id = object_id(N'[dbo].[PK_TTM–¼Žhƒf[ƒ^F]')) begin ALTER TABLE [dbo].[WORK_TTM–¼Žhƒf[ƒ^F] DROP PK_TTM–¼Žhƒf[ƒ^F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TTXƒ[ƒ‹F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TTXƒ[ƒ‹F]') AND id = object_id(N'[dbo].[PK_TTXƒ[ƒ‹F]')) begin ALTER TABLE [dbo].[WORK_TTXƒ[ƒ‹F] DROP PK_TTXƒ[ƒ‹F end end if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_TTX•¶‘F]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) begin if exists (select * from dbo.sysobjects where parent_obj = object_id(N'[dbo].[WORK_TTX•¶‘F]') AND id = object_id(N'[dbo].[PK_TTX•¶‘F]')) begin ALTER TABLE [dbo].[WORK_TTX•¶‘F] DROP PK_TTX•¶‘F end end if ( exists (SELECT * FROM syscolumns WHERE OBJECT_NAME(id) = 'TGAŽèŒ`F' AND name = N'•¶‘“à—eCD')) and (not( exists (SELECT * FROM syscolumns WHERE OBJECT_NAME(id) = 'TGAŽèŒ`F' AND name = N'ŽèŒ`”Ô†'))) begin if exists (SELECT * FROM syscolumns WHERE OBJECT_NAME(id) = 'TGAŽèŒ`F' AND name = N'PK_TGAŽèŒ`F') begin ALTER TABLE [dbo].[TGAŽèŒ`F] DROP PK_TGAŽèŒ`F end CREATE TABLE [dbo].[TGAŽèŒ`FPRE] ( [ƒVƒXƒeƒ€CD] [varchar] (12) NOT NULL , [‰‰KCD] [varchar] (12) NOT NULL , [‰ïŽÐCD] [varchar] (20) NOT NULL , [쬉ïŽÐCD] [varchar] (20) NOT NULL , [•¶‘Ží—ÞCD] [varchar] (2) NOT NULL , [•¶‘“à—eCD] [varchar] (20) NOT NULL , [ŽèŒ`”Ô†] [varchar] (20) NULL , [‘—ŽóM‹æ•ª] [varchar] (2) NULL , [Žæˆø“ú] [datetime] NULL , [UolCD] [varchar] (20) NULL , [ŽóŽælCD] [varchar] (20) NULL , [ˆøŽólCD] [varchar] (20) NULL , [— ‘lCD] [varchar] (20) NULL , [”í— ‘lCD] [varchar] (20) NULL , [Žx•¥Šú“ú] [datetime] NULL , [‹àŠz] [money] NULL , [Žx•¥êŠCD] [varchar] (20) NULL , [“E—v] [varchar] (40) NULL , [“^––‹æ•ª] [varchar] (2) NULL , [“^––“ú] [datetime] NULL , [“^––“E—v] [varchar] (20) NULL , [—˜‘§‹àŠz] [money] NULL , [”­sƒtƒ‰ƒO] [smallint] NULL , [ŠJ••ƒtƒ‰ƒO] [smallint] NULL , [휃tƒ‰ƒO] [smallint] NULL , [Šw¶”Ô†] [varchar] (12) NULL , [—\”õ‚ ] [varchar] (200) NULL , [—\”õ‚¢] [varchar] (200) NULL , [—\”õ‚¤] [varchar] (200) NULL , [—\”õ1] [int] NULL , [—\”õ2] [int] NULL , [—\”õ3] [int] NULL ) INSERT INTO TGAŽèŒ`FPRE SELECT ƒVƒXƒeƒ€CD, ‰‰KCD, ‰ïŽÐCD, 쬉ïŽÐCD, •¶‘Ží—ÞCD, •¶‘“à—eCD, •¶‘“à—eCD, ‘—ŽóM‹æ•ª, Žæˆø“ú, UolCD, ŽóŽælCD, ˆøŽólCD, — ‘lCD, ”í— ‘lCD, Žx•¥Šú“ú, ‹àŠz, Žx•¥êŠCD, “E—v, “^––‹æ•ª, “^––“ú, “^––“E—v, —˜‘§‹àŠz, ”­sƒtƒ‰ƒO, ŠJ••ƒtƒ‰ƒO, 휃tƒ‰ƒO, Šw¶”Ô†, —\”õ‚ , —\”õ‚¢, —\”õ‚¤, —\”õ1, —\”õ2, —\”õ3 FROM TGAŽèŒ`F EXEC sp_rename 'TGAŽèŒ`F', 'WORK_050221TGAŽèŒ`F' EXEC sp_rename 'TGAŽèŒ`FPRE', 'TGAŽèŒ`F' end SELECT * INTO dbo.YTMP_TC4‰‰K‹–‰ÂŠw¶ƒOƒ‹[ƒvM FROM TC4‰‰K‹–‰ÂŠw¶ƒOƒ‹[ƒvM WHERE 1 = 0 SELECT * INTO dbo.YTMP_TDA•ñ‘‘Ž®M FROM TDA•ñ‘‘Ž®M WHERE 1 = 0 SELECT * INTO dbo.YTMP_TGA“üoŒÉ–¾×TRN FROM TGA“üoŒÉ–¾×TRN WHERE 1 = 0 SELECT * INTO dbo.YTMP_TGB‹âsŒûÀ“üo‹àTRN FROM TGB‹âsŒûÀ“üo‹àTRN WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK“`•[–¾×F FROM TSK“`•[–¾×F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK’ •ë_Žd–ó“ú‹L’ F FROM TSK’ •ë_Žd–ó“ú‹L’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK’ •ë_Žd–óWŒv•\F FROM TSK’ •ë_Žd–óWŒv•\F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK’ •ë_”ªŒ…¸ŽZ•\F FROM TSK’ •ë_”ªŒ…¸ŽZ•\F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK’ •ë_‡ŒvŽc‚ŽŽŽZ•\F FROM TSK’ •ë_‡ŒvŽc‚ŽŽŽZ•\F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK’ •ë_‘¹‰vŒvŽZ‘F FROM TSK’ •ë_‘¹‰vŒvŽZ‘F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK’ •ë_‘Š¨’茳’ F FROM TSK’ •ë_‘Š¨’茳’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK’ •ë_‘ÝŽØ‘ÎÆ•\F FROM TSK’ •ë_‘ÝŽØ‘ÎÆ•\F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK•â••ë_Žd“ü’ F FROM TSK•â••ë_Žd“ü’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK•â••ë_ŽóŽæŽèŒ`‹L“ü’ F FROM TSK•â••ë_ŽóŽæŽèŒ`‹L“ü’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK•â••ë_¤•i—L‚’ F FROM TSK•â••ë_¤•i—L‚’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK•â••ë_”„ã’ F FROM TSK•â••ë_”„ã’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK•â••ë_”„Š|‹àŒ³’ F FROM TSK•â••ë_”„Š|‹àŒ³’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK•â••ë_“–À—a‹ào”[’ F FROM TSK•â••ë_“–À—a‹ào”[’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK•â••ë_Žx•¥ŽèŒ`‹L“ü’ F FROM TSK•â••ë_Žx•¥ŽèŒ`‹L“ü’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK•â••ë_Œ»‹ào”[’ F FROM TSK•â••ë_Œ»‹ào”[’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TSK•â••ë_”ƒŠ|‹àŒ³’ F FROM TSK•â••ë_”ƒŠ|‹àŒ³’ F WHERE 1 = 0 SELECT * INTO dbo.YTMP_TTL‡•¹Žc‚F FROM TTL‡•¹Žc‚F WHERE 1 = 0 UPDATE TDAŠ¨’è‰È–ÚM SET TDAŠ¨’è‰È–ÚM.“Á•ÊŠ¨’è‹æ•ª = 'DT' FROM TDAŠ¨’è‰È–ÚM WHERE Š¨’èCD = 'B111' AND (SELECT COUNT(*) FROM TDAŠ¨’è‰È–ÚM WHERE “Á•ÊŠ¨’è‹æ•ª = 'DT' GROUP BY “Á•ÊŠ¨’è‹æ•ª) = 0 UPDATE TDAŠ¨’è‰È–ÚM SET TDAŠ¨’è‰È–ÚM.“Á•ÊŠ¨’è‹æ•ª = 'DU' FROM TDAŠ¨’è‰È–ÚM WHERE Š¨’èCD = 'B999' AND (SELECT COUNT(*) FROM TDAŠ¨’è‰È–ÚM WHERE “Á•ÊŠ¨’è‹æ•ª = 'DU' GROUP BY “Á•ÊŠ¨’è‹æ•ª) = 0 UPDATE TDAŠ¨’è‰È–ÚM SET TDAŠ¨’è‰È–ÚM.“Á•ÊŠ¨’è‹æ•ª = A.‹æ•ªCD FROM TDAŠ¨’è‰È–ÚM INNER JOIN (SELECT * FROM TC9‹æ•ªM WHERE (ƒf[ƒ^Ž¯•Ê = '“Á•ÊŠ¨’è‹æ•ª')) A ON TDAŠ¨’è‰È–ÚM.ƒVƒXƒeƒ€CD = A.ƒVƒXƒeƒ€CD AND REPLACE(REPLACE(TDAŠ¨’è‰È–ÚM.Š¨’è–¼Ì, '@', ''), ' ', '') = A.‹æ•ª–¼Ì AND TDAŠ¨’è‰È–ÚM.‹ÆŽíCD = 'S'