SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @HostOrderBytes BINARY(16) = 0x33221100554477668899aabbccddeeff
DECLARE @Result UNIQUEIDENTIFIER = CONVERT(UNIQUEIDENTIFIER, @HostOrderBytes)
SELECT @Result -- 00112233-4455-6677-8899-aabbccddeeff

(No column name)

00112233-4455-6677-8899-aabbccddeeff

DECLARE @NetworkOrderBytes BINARY(16) = 0x00112233445566778899aabbccddeeff

DECLARE @HostOrderBytes BINARY(16) =
    SUBSTRING(@NetworkOrderBytes,4,1)   -- Reverse bytes 1-4 (0-3)
    + SUBSTRING(@NetworkOrderBytes,3,1)
    + SUBSTRING(@NetworkOrderBytes,2,1)
    + SUBSTRING(@NetworkOrderBytes,1,1)
    + SUBSTRING(@NetworkOrderBytes,6,1) -- Reverse bytes 5-6 (4-5)
    + SUBSTRING(@NetworkOrderBytes,5,1)
    + SUBSTRING(@NetworkOrderBytes,8,1) -- Reverse bytes 7-8 (6-7)
    + SUBSTRING(@NetworkOrderBytes,7,1)
    + SUBSTRING(@NetworkOrderBytes,9,8) -- Remaining bytes are unchanged

DECLARE @Result UNIQUEIDENTIFIER = CONVERT(UNIQUEIDENTIFIER, @HostOrderBytes)

SELECT @Result -- 00112233-4455-6677-8899-aabbccddeeff

(No column name)

00112233-4455-6677-8899-aabbccddeeff

DECLARE @NetworkOrderBytes BINARY(16) = 0x00112233445566778899aabbccddeeff

DECLARE @Result UNIQUEIDENTIFIER =
    CONVERT(UNIQUEIDENTIFIER,
       STUFF(STUFF(STUFF(STUFF(
           CONVERT(VARCHAR(50), @NetworkOrderBytes, 2),
           9 , 0, '-'), 14, 0, '-'), 19, 0, '-'), 24, 0, '-'))

SELECT @Result -- 00112233-4455-6677-8899-aabbccddeeff

(No column name)

00112233-4455-6677-8899-aabbccddeeff