Viewing 15 posts - 1,396 through 1,410 (of 4,820 total)
April 30, 2018 at 8:04 am
Wondering if you have any kind of setting that automatically translates TABs into spaces?
April 30, 2018 at 7:44 am
I would much sooner believe that the error came from the INSERT where a varchar(50) value didn't conform to a format necessary for a date or datetime value.
April 30, 2018 at 6:56 am
I ran into an interesting issue yesterday which i managed to resolve but couldn't...
April 30, 2018 at 6:49 am
April 27, 2018 at 12:26 pm
April 27, 2018 at 12:22 pm
d_george - Friday, April 27, 2018 11:57 AMDoes it work for you?
That doesn't answer the question. But to answer yours, I'll have...
April 27, 2018 at 12:11 pm
April 27, 2018 at 12:03 pm
d_george - Friday, April 27, 2018 11:22 AMFind & replace.
And have you tried copying and pasting existing tabbed text into the search...
April 27, 2018 at 11:53 am
April 27, 2018 at 11:44 am
I'm not sure there's a good way to avoid it. Do you need to eliminate a comma between the City and postcode ? Because you appear to have address data...
April 27, 2018 at 11:29 am
April 27, 2018 at 10:37 am
April 27, 2018 at 10:16 am
Let's just fix it:SELECT ContactEnrollDate
FROM PersonalProfiles
WHERE YEAR(ContactEnrollDate) = 2006
AND MONTH(ContactEnrollDate) IN (3,12)
AND ContactCancelDate IS NOT NULL
AND LastAttended IS NOT NULL;
April 27, 2018 at 9:06 am
Viewing 15 posts - 1,396 through 1,410 (of 4,820 total)