create table table_name(ID nvarchar(max),LDID nvarchar(max),CusDI nvarchar(max));
insert into table_name(ID,LDID,CusDI)values('20140411002','LD0000240301','003045');
insert into table_name(ID,LDID,CusDI)values('20140411005','LD0000350301','003074');
insert into table_name(ID,LDID,CusDI)values('20140411007','LD0000250301','003049');
insert into table_name(ID,LDID,CusDI)values('20140411008','LD0000390301','003073');
insert into table_name(ID,LDID,CusDI)values('20140411009','LD0000300301','003058');
SELECT cast(substring(replace(ID,',',''),0,len(replace(ID,',',''))-2) as nvarchar)+'-04-'+cast(substring(replace(ID,',',''),9,len(replace(ID,',',''))-2) as nvarchar) as ID,LDID,CusDI from table_name