Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
select ch.file_ID, COUNT (*) from OPID_POSTPAY_BCBSNE_CORELINK_PURGE_ORIG.CLAIM_HISTORY ch INNER JOIN ( SELECT DISTINCT OPID_POSTPAY_BCBSNE_CORELINK_PURGE.CLM_KY FROM OPID_POSTPAY_BCBSNE_CORELINK_PURGE.PURGE_STRIP WHERE OPID_POSTPAY_BCBSNE_CORELINK_PURGE.[FILE_ID] = 41552 and OPID_POSTPAY_BCBSNE_CORELINK_PURGE.HST_FG = 1 ) ct on ch.CLM_KY = ct.CLM_KY Group by ch.FILE_ID
Then the query would be:
INSERT INTO #CLAIM_TEMP (CLM_KY) SELECT DISTINCT CLM_KY FROM PURGE_STRIP WHERE [FILE_ID] = @fileId and HST_FG = 1
FROM CLAIM_HISTORY ch WITH(NOLOCK) INNER JOIN #CLAIM_TEMP ct on ch.CLM_KY = ct.CLM_KY
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.