Viewing 15 posts - 691 through 705 (of 1,468 total)
Sorry, but that doesn't read right. I seem to be having trouble articulating what my mind is thinking.
Perhaps the CONVERT() documentation might help.
October 15, 2018 at 2:10 pm
October 15, 2018 at 2:07 pm
Thanks for your suggestion, but when I try it, I'm getting an "Explicit conversion...
October 15, 2018 at 1:47 pm
It appears that your ReportDateYearMonthg is a char(6) value.
This should do the trickSELECT DATEADD(MONTH, -1, CONVERT(date, ppr.ReportDateYearMonth+'01', 112)) AS PeriodEndCalendar
October 15, 2018 at 1:30 pm
October 15, 2018 at 12:13 pm
October 13, 2018 at 5:53 am
frederico_fonseca - Saturday, October 13, 2018 5:22 AMHehe... bit too advanced for the OP 😀
Nah. He's pretty good with SQL ....
October 13, 2018 at 5:40 am
update...
October 13, 2018 at 5:16 am
Thanks for your response, I had tried the same also, that is using ISACTIVE...
October 12, 2018 at 1:30 pm
I need help with the below. When I am trying to run the below...
October 12, 2018 at 1:08 pm
Based on the limited information that you have provided, I would try the following code.
Note, this is untested code, as I have nothing to test it against. The code...
October 12, 2018 at 1:04 pm
October 12, 2018 at 11:10 am
Oh, that thread is keeping me sane. Much more entertaining than watching the contractors fit new ceilings in my lounge
October 12, 2018 at 4:59 am
ChrisM@Work - Friday, October 12, 2018 4:29 AMI think the secret view guy is just bored.
You mean ...
My Girl Friend and...
October 12, 2018 at 4:46 am
Viewing 15 posts - 691 through 705 (of 1,468 total)