Thank you, @frederico_fonseca. I tried your test query but it's not returning the record with the PolicyAgreementNumber in question. As for triggers, my department doesn't utilize any in the DataMart....

Thanks, @Mike01. PolicyExpirationDate is of datatype datetimeoffset(7). I tried using the following for ActivationDate and it seems to have fixed the issue:

 TRY_CONVERT(datetime,(select max(s2.EffectiveDate) from PolicyStatus S2 where s.PolicyId...

Thanks guys for your replies. @JeffModen, it's actually not a production server, but rather a copy of the data from a production server. So this seemed to have done the...

Thanks for your input as well, Jeffrey Williams. I do have a question...does anyone know how to get the last day of the month, instead of using the '01'? I'm...

Thanks, @DesNorton....that actually fixed the issue! You're a genius! Could you please explain why that worked? I'm not clear on why we needed to cast to a char. Thanks again!

Hi @DesNorton,

Thanks for your suggestion, but when I try it, I'm getting an "Explicit conversion from data type int to date is not allowed" error...the ReportDateYearMonth field is...

Hey All,

Thanks for your input. I was able to get some help on this and ended up using a cte:

unique_results...

Thanks for your reply, Phil. I don't have any 3rd party components installed. It's the strangest thing...the error has ceased for now...hopefully won't have to revisit this. Thanks for your...

Good question......it...

Good point, Drew. I removed the parens, but it's still not ordering by correctly. Any thoughts? Thanks.

Thanks, @ScottPletcher ! I'll try to incorporate your suggestion into my query...you're brilliant :smooooth:

Thanks, @ScottPletcher. I appreciate the clarification...I'll see if I can try implementing this into the solution. 🙂

Thanks for all of your input, folks.

@ScottPletcher , I'm able to somewhat understand your solution,...

Thanks for your input, Jack. The issue has since subsided, but I'll keep your suggestion in mind in case it resurfaces 🙂.