<div>
<blockquote>
I can provide some basic column names and data -- at this point I need more help jump-starting how to tackle the process!
</blockquote>
<br />
This will help to get our teeth stuck into your problem.....
</div>


> I can provide some basic column names and data -- at this point I need more help jump-starting how to tackle the process!


This will help to get our teeth stuck into your problem.....

<div>
Thank you very much for your help!
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
My thanks in advance for your assistance...<br />
<br />
Code-wise, I am having a hard time with my SQL trying to figure out who has never had a claim for a certain time period yet is a member during the same time period.<br />
<br />
It is easy for those with any claims between start_dt and end_dt but to state having a count of zero or NULL claims I realize is not logical.<br />
<br />
The basic tables I am working with are MEMBERS and MASTER_CLAIM and maybe need to pull in a membership view vmembership.<br />
<br />
I can provide some basic column names and data -- at this point I need more help jump-starting how to tackle the process!
</div>
</div>


Hi Experts,

My thanks in advance for your assistance...

Code-wise, I am having a hard time with my SQL trying to figure out who has never had a claim for a certain time period yet is a member during the same time period.

It is easy for those with any claims between start_dt and end_dt but to state having a count of zero or NULL claims I realize is not logical.

The basic tables I am working with are MEMBERS and MASTER_CLAIM and maybe need to pull in a membership view vmembership.

I can provide some basic column names and data -- at this point I need more help jump-starting how to tackle the process!

Assistance finding members with no claims

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.