Viewing 15 posts - 16 through 30 (of 106 total)
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...
January 2, 2019 at 12:21 pm
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...
January 2, 2019 at 11:22 am
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...
October 22, 2018 at 12:30 pm
October 15, 2018 at 3:02 pm
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...
October 15, 2018 at 2:49 pm
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....
October 15, 2018 at 1:54 pm
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...
October 15, 2018 at 1:44 pm
Hey All,
Thanks for your input. I was able to get some help on this and ended up using a cte:
unique_results...
October 15, 2018 at 1:02 pm
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...
October 15, 2018 at 12:52 pm
ZZartin - Wednesday, September 26, 2018 2:52 PMWhat's not ordering correctly? The query or when you select from the temp table?
Good question......it...
September 26, 2018 at 2:57 pm
Good point, Drew. I removed the parens, but it's still not ordering by correctly. Any thoughts? Thanks.
September 26, 2018 at 2:47 pm
Thanks, @scottpletcher ! I'll try to incorporate your suggestion into my query...you're brilliant :smooooth:
September 7, 2018 at 10:59 am
Thanks, @scottpletcher. I appreciate the clarification...I'll see if I can try implementing this into the solution. 🙂
July 17, 2018 at 2:28 pm
July 12, 2018 at 12:37 pm
Thanks for your input, Jack. The issue has since subsided, but I'll keep your suggestion in mind in case it resurfaces 🙂.
June 14, 2018 at 8:27 am
Viewing 15 posts - 16 through 30 (of 106 total)