End Google Ads 201810 - BS.net 01 --> Hi Guys,

I am having problem when running the Following SQL script.It takes Pretty long time to return result.
I am having about 500,000 records in my database.


select count(distinct(CR_Cli)),SO_name from Callrecords inner join dbo.StudioOperators
On CR_StudioOperatorID=SO_ID
where datename(month,cr_callstart)='April'
and Cr_cli not in (select Cr_cli from Callrecords where cr_callstart