Convert a SQL Query to Enhanced execution query

[julfikar]

Can someone help me in converting below sql query into an Enhanced execution query (update operation)

1)  update accounts set status='SUSPENDED FROM IMPORT SERVICE' where endpointkey=12 and name like '%on-%' and status in ('2','Manually Suspended');

2) 

UPDATE accounts ac, user_accounts ua SET ac.accounttype='P' WHERE ua.accountkey = ac.accountkey AND ac.status='1' and ac.name not like '%\_%' and ac.accounttype is null and ac.endpointkey=13

[Raghu]

@julfikar 

1 st query :;

select 'SUSPENDED FROM IMPORT SERVICE' as accounts__status,a.accountkey as accounts__primarykey from accounts a where a.ENDPOINTKEY = 12 and a.name like '%on-%' and status in ('2','Manually Suspended');

2nd query have "user_accounts " this table dont have permissin update via script try other way

UPDATE accounts ac, user_accounts ua SET ac.accounttype='P' WHERE ua.accountkey = ac.accountkey AND ac.status='1' and ac.name not like '%\_%' and ac.accounttype is null and ac.endpointkey=13