users

select * from cmusxhd

update Testmhaq_CureMD..CMUSXHD
set vuname=’mdadminmhaqtst’
where VUNAME=’mdadminmhaq’

–insert into controldb..practiceuserdata(vusername,curemd_dsn_name,curepatient_dsn_name,curemobile_dsn_name,curemd_db_name,curepatient_db_name,curemobile_db_name,curemdimage_db_name,curemd_userid,curemd_password)
SELECT DISTINCT RTRIM(LTRIM(vuname)),’Testmhaq_CureMD’,’Testmhaq_CurePatient’,’Testmhaq_CureMobile’,
‘Testmhaq_CureMD’,’Testmhaq_CurePatient’,’Testmhaq_CureMobile’, ‘Testmhaq_CureImage’,’curemd’,’cure2000′
FROM Testmhaq_CureMD.dbo.cmusxhd
WHERE RTRIM(LTRIM(vuname)) NOT IN
(
SELECT vUserName FROM controldb..PRACTICEUSERDATA
)
AND VUNAME”
and len(RTRIM(LTRIM(vuname)))<=16

update CMUSXHD
set VPASSWORD=’a41c1199d6fdba0d0230d5103b0e715d’
,bpasswordrest=0

where VUNAME=’mdadminhfspctst’