Viewing 15 posts - 61 through 75 (of 214 total)
'%[^-a-zA-Z0-9.&_#$\\() ]%'April 13, 2018 at 11:08 am
April 13, 2018 at 11:02 am
drew.allen - Monday, January 29, 2018 1:21 PMSince you're on SQL 2012, you can use TRY_CAST() instead of just CAST().Drew
forgot about the...
January 29, 2018 at 1:37 pm
October 20, 2017 at 3:19 pm
On another update, I am getting the same error msg and I can't find the needle in the haystack. I was thinking of doing an update on a portion of...
October 20, 2017 at 2:55 pm
October 20, 2017 at 2:49 pm
October 20, 2017 at 1:16 pm
October 20, 2017 at 11:52 am
I have another hurtle... This date format: '15 Mar 2017'
I am getthing an error msg when trying to update the dates:
Conversion failed when converting date and/or time...
October 20, 2017 at 9:55 am
DesNorton,
I excluded the month > 12 and the error msg is gone.
SELECT PTL_StartDate, PTL_EndDate
INTO #Staging
FROM XLSHdr_Promo_TescoUK
WHERE (PTL_StartDate LIKE '[0-3][0-9].[0-1][0-9].[0-9][0-9][0-9][0-9]' OR PTL_StartDate LIKE...
October 19, 2017 at 12:48 pm
I think SQL Pirate is right, there could be some records with dates that have mmddyyyy instead of ddmmyyyy and this is causing the conversion failure error. I would have...
October 19, 2017 at 12:44 pm
October 19, 2017 at 11:57 am
October 19, 2017 at 10:04 am
Ok, so i was able to get past the hurdle. It worked for me. Thanks everyone!
October 18, 2017 at 2:20 pm
Viewing 15 posts - 61 through 75 (of 214 total)