Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
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
|SQL Username continuously being disabled in SQL Server HA Cluster||13||29|
|replication - alerts?||4||23|
|BULK INSERT most recent CSV||19||21|
|Safely Uninstall SQL Server 2008 R2 Express||3||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!