So use the same SELECT statement, but just add INSERT on top;
INSERT (col1, col2, col3, ..) SELECT ..., quotname(Manager, ''''), ...
Note that quotename will return NULL if the input is more than 128 characters.
Note also that qoutename will also double any single quotes in the Manager column. So
Brian O'Brien will result in