Generate SQL to create MSSQL logins with same SID and password

mirror-logins.sql

-- SQL Server Logins
select 
       'create login [' + sp.[name] + '] with password=0x' + CONVERT(nvarchar(max), l.password_hash, 2) + ' hashed, sid=0x' + convert(nvarchar(2000), sp.[sid], 2) + ', default_language = [us_english];'
from
       master.sys.server_principals sp
       inner join master.sys.sql_logins l on sp.[sid] = l.[sid]
where
       sp.type_desc = 'SQL_LOGIN'
       and sp.is_disabled = 0
       and sp.default_language_name = 'us_english'     -- helps target the specifically created logins
order by 
       sp.[name]