Viewing 15 posts - 781 through 795 (of 26,487 total)
And FYI, my testing code seems to work just fine:
declare @TestString varchar(64) = '"angelina.uhi@ors.org oladi.ade@ors.org"';
select
@TestString
, left(@TestString,charindex(' ',@TestString))
October 29, 2018 at 12:06 pm
Thank you so much:
so it works for this:
"bassam.nasser@crs.org julia.leis@crs.org"
t doesn't work for this:
October 29, 2018 at 11:59 am
October 29, 2018 at 11:55 am
And you might want to try this:
--want to replace names in this table with '' if they are in #test table
if object_id('tempdb..#Target') is not null
October 29, 2018 at 11:42 am
When I cut/paste code from the SQL query window into this area I...
October 29, 2018 at 11:27 am
October 29, 2018 at 11:20 am
October 26, 2018 at 1:43 pm
October 26, 2018 at 10:13 am
SELECT a.icode,a.categorycode,a.description,sum(qty),date from items a
inner...
October 26, 2018 at 8:20 am
October 25, 2018 at 2:40 pm
People literally do use gui's on SQL server in real world environments. Once you...
October 25, 2018 at 1:33 pm
(LEFT([Person Email],(CHARINDEX(' ',[Person Email])-1),REPLACE([Person...
October 25, 2018 at 12:05 pm
Viewing 15 posts - 781 through 795 (of 26,487 total)