Viewing 15 posts - 1,951 through 1,965 (of 2,537 total)
SELECT [Person Email_old], T.CleanedPersonEmailold, LEFT(T.CleanedPersonEmailold,CHARINDEX(' ',T.CleanedPersonEmailold)-1) SingleEmail
FROM Person_oldemail
CROSS APPLY(VALUES (REPLACE(REPLACE(REPLACE([Person Email_old],CHAR(13),' '),CHAR(10),' '),'"','')+' ')) T(CleanedPersonEmailold)
October 30, 2018 at 10:52 am
October 30, 2018 at 10:13 am
October 25, 2018 at 5:11 am
October 24, 2018 at 4:23 pm
October 24, 2018 at 3:51 pm
I thought I'd try to do it with cross apply, I was successful up to 12 columns but then 13 broke SQL Server
Msg 8632, Level 17,...
October 24, 2018 at 2:17 pm
October 24, 2018 at 12:19 pm
Viewing 15 posts - 1,951 through 1,965 (of 2,537 total)