INSERT INTO userdetail (

user_id_userdetail, password_userdetail, first_name_userdetail, 

email_userdetail, phone_num_userdetail, user_type_userdetail,  

customer_id_userdetail, licenseagreementaccepted_userdetail, is_sso_userdetail) 

VALUES  (

'1_auto_generated_user', REPLACE(newid(),'-',''), 'User', 

'sso#1' , '0', '0', 

'1', '1', '0')

GO



UPDATE UD2

SET UD2.userpermissionroleid_userdetail = UD1.userpermissionroleid_userdetail,

UD2.jobpermissiontemplateid_userdetail = UD1.jobpermissiontemplateid_userdetail,

UD2.grouppermissiontemplateid_userdetail = UD1.grouppermissiontemplateid_userdetail

FROM userdetail UD1

INNER JOIN userdetail UD2 ON (UD1.customer_id_userdetail = UD2.customer_id_userdetail)

WHERE UD2.user_id_userdetail = '1_auto_generated_user' 

AND UD2.customer_id_userdetail = '1'

AND UD1.user_id_userdetail = '<UserID of Customer ID = 1>';