• Database server: OMONODEPROD01\OMDDBPROD03
• Database name: OMD_Rptg
• Table name: dbo.MMIS Pharma Claim (based on the selected table in SQL Server Management Studio)
• Version SQL Server 2019 - want to refresh the table to Retrieve the latest data from the source and replace the existing data in the table... please how do i fresh this table in SQL server database...

Transcribed Image Text:

SQLQuery2.sql - OMDNODEPROD01\OMDDBPROD03.OMD_Rptg View Project Tools Window Help -O-B OMD_Rptg Edit Explorer ect - = O Debug New Query dbo.MHCLDSHD dbo.MHCLDSHID dbo.MHCLDSHID_STRIP dbo.MHCLDSHR dbo.MHCLDState dbo.MHCLDState_FY20 dbo.MHCLDState_FY21 dbo.MHCLDSTATE_FY22 dbo.MHCLDStateSHID Execute Debug 4 dbo.MHCLDStateSHID_FY20 dbo.MHCLDStateSHID_FY21 dbo.MHCLDSTATESHID_FY22 dbo.missing_clms_11182021_new Fdbo.Missing_Denied_Claims dbo.MissingAnalysis_1102 dbo.Missing Denied Claims_NoDups dbo.MISSINGPRA dbo.MISSINGPRA_FINAL0221 dbo.MMIS_Drug_Info dbo.MMIS_Pharma_Claim dbo.MMIS_PHARMA_CLAIM_TMP dbo.MMIS_PHARMA_CLAIM_TMP1 dbo.No_Engagement Providers_Sheet1 dbo.No_Engagement Providers_Sheet2 dbo.OLE DB Destination dbo.OLE_DB_Destination dbo.OMD_835_FF_CHKREG_REPORT_CC dbo.OMD_835_FF_CHKREG_REPORT_CC dbo.OMD_835_FLATFILE_CHKREG_REP dbo.OMD_835_FLATFILE_CHKREG_REPC dbo.OMD_835_FLATFILE_CHKREG_REP( dbo.OMD_835_FLATFILE_CHKREG_REP dbo.OMD_835_FLATFILE_CHKREG_REPC dbo.OMD_835_FLATFILE_CLMS_ORIG_S 90% (INFOMC\fabuah (69))* - Microsoft SQL Server Management Studio X SQLQuery2.sql - O... FOMC\fabuah (69))* X select from MMIS_Pharma_Claim FLE 12 2-C -| Results Messages ICN_NUMBER 1 32208202515212400 2 32208202518682000 3 32208202518682700 4 32208202515956400 5 32208202521696700 6 32208202519777800 7 32208202520641400 8 32208202523277900 9 32208202515461300 10 32208202517073900 11 32208202518674200 12 32208202523917000 13 32208202516713.500 Query canceled. 9 ACCOUNT CODE CLAIM_STATUS 0 0 0 0 0 0 0 0 0 0 0 0 0 P P P P P P P P P P Pa P aa P P Ab P P P P CLAIM_TYPE FIRST_DATE_OF_SVC LAST_DATE_OF_SVC DATE_PAID ORIG_PAY_DATE RECIP_PAY_AMT 03/26/2022 03/26/2022 01/01/0001 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 03/26/2022 01/01/0001 01/01/0001 03/26/2022 01/01/0001 01/01/0001 03/26/2022 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 P P P P P P aaa 16 P P. Generic Debugger P 03/17/2022 03/21/2022 03/21/2022 03/18/2022 03/22/2022 03/21/2022 03/22/2022 03/23/2022 03/18/2022 03/19/2022 03/21/2022 03/23/2022 03/18/2022 Quick Launch (Ctrl+Q) 03/17/2022 03/21/2022 03/21/2022 03/18/2022 03/22/2022 03/21/2022 03/22/2022 03/23/2022 03/18/2022 03/19/2022 03/21/2022 03/23/2022 03/18/2022 0000100 0000100 0000000 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000000 D P AMT_PAID BY 000000000 000000000 000000000 000000000 000000000 000000000 000000000 00000000 00000000 00000001 0000000 0000000 000000 OMDNODEPROD01\OMDDBPROD03 (... INFOMC\fabuah (69) OMD_Rptg 9 SQLQuery2.sql - OMDNODEPROD01\OMDDBPROD03.OMD_Rptg View Project Tools Window Help -O-B OMD_Rptg Edit Explorer ect - = O Debug New Query dbo.MHCLDSHD dbo.MHCLDSHID dbo.MHCLDSHID_STRIP dbo.MHCLDSHR dbo.MHCLDState dbo.MHCLDState_FY20 dbo.MHCLDState_FY21 dbo.MHCLDSTATE_FY22 dbo.MHCLDStateSHID Execute Debug 4 dbo.MHCLDStateSHID_FY20 dbo.MHCLDStateSHID_FY21 dbo.MHCLDSTATESHID_FY22 dbo.missing_clms_11182021_new Fdbo.Missing_Denied_Claims dbo.MissingAnalysis_1102 dbo.Missing Denied Claims_NoDups dbo.MISSINGPRA dbo.MISSINGPRA_FINAL0221 dbo.MMIS_Drug_Info dbo.MMIS_Pharma_Claim dbo.MMIS_PHARMA_CLAIM_TMP dbo.MMIS_PHARMA_CLAIM_TMP1 dbo.No_Engagement Providers_Sheet1 dbo.No_Engagement Providers_Sheet2 dbo.OLE DB Destination dbo.OLE_DB_Destination dbo.OMD_835_FF_CHKREG_REPORT_CC dbo.OMD_835_FF_CHKREG_REPORT_CC dbo.OMD_835_FLATFILE_CHKREG_REP dbo.OMD_835_FLATFILE_CHKREG_REPC dbo.OMD_835_FLATFILE_CHKREG_REP( dbo.OMD_835_FLATFILE_CHKREG_REP dbo.OMD_835_FLATFILE_CHKREG_REPC dbo.OMD_835_FLATFILE_CLMS_ORIG_S 90% (INFOMC\fabuah (69))* - Microsoft SQL Server Management Studio X SQLQuery2.sql - O... FOMC\fabuah (69))* X select from MMIS_Pharma_Claim FLE 12 2-C -| Results Messages ICN_NUMBER 1 32208202515212400 2 32208202518682000 3 32208202518682700 4 32208202515956400 5 32208202521696700 6 32208202519777800 7 32208202520641400 8 32208202523277900 9 32208202515461300 10 32208202517073900 11 32208202518674200 12 32208202523917000 13 32208202516713.500 Query canceled. 9 ACCOUNT CODE CLAIM_STATUS 0 0 0 0 0 0 0 0 0 0 0 0 0 P P P P P P P P P P Pa P aa P P Ab P P P P CLAIM_TYPE FIRST_DATE_OF_SVC LAST_DATE_OF_SVC DATE_PAID ORIG_PAY_DATE RECIP_PAY_AMT 03/26/2022 03/26/2022 01/01/0001 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 03/26/2022 01/01/0001 01/01/0001 03/26/2022 01/01/0001 01/01/0001 03/26/2022 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 P P P P P P aaa 16 P P. Generic Debugger P 03/17/2022 03/21/2022 03/21/2022 03/18/2022 03/22/2022 03/21/2022 03/22/2022 03/23/2022 03/18/2022 03/19/2022 03/21/2022 03/23/2022 03/18/2022 Quick Launch (Ctrl+Q) 03/17/2022 03/21/2022 03/21/2022 03/18/2022 03/22/2022 03/21/2022 03/22/2022 03/23/2022 03/18/2022 03/19/2022 03/21/2022 03/23/2022 03/18/2022 0000100 0000100 0000000 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000000 D P AMT_PAID BY 000000000 000000000 000000000 000000000 000000000 000000000 000000000 00000000 00000000 00000001 0000000 0000000 000000 OMDNODEPROD01\OMDDBPROD03 (... INFOMC\fabuah (69) OMD_Rptg 9