This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.
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
|T-SQL--Two Different Totals Even with the Same Concept||6||46|
|Query / Window function ?||3||18|
|Help Parsing a String with SQL Syntax||23||33|
|T-SQL: Carrying a Figure from One Row to the Next||15||38|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!