public static class BIN2GUID
{
    [SqlFunction(FillRowMethodName = "getUid_getRow")]
    public static IEnumerable getUid(byte[] c_guid)
    {
        return new UidsRecord[] { new UidsRecord(c_guid) };
    }


    public static void getUid_getRow(object obj, out SqlGuid c_guid)
    {
        UidsRecord o = (UidsRecord)obj;
        c_guid = new SqlGuid(o.c_guid);
    }


    public class UidsRecord
    {
        public byte[] c_guid;

        public UidsRecord(byte[] a_guid)
        {
            formatBytes(a_guid, out c_guid);
        }

        private void formatBytes(byte[] buffer1, out byte[] buffer2)
        {
            buffer2 = new byte[] {
                                   buffer1[15],
                                   buffer1[14],
                                   buffer1[13],
                                   buffer1[12],
                                   buffer1[11],
                                   buffer1[10],
                                   buffer1[9],
                                   buffer1[8],
                                   buffer1[0],
                                   buffer1[1],
                                   buffer1[2],
                                   buffer1[3],
                                   buffer1[4],
                                   buffer1[5],
                                   buffer1[6],
                                   buffer1[7]
            };
        }
    }

}

[src]select top 1000
				x1.c_guid as fk_agr,
				x2.c_guid as fk_obj,
				x3.c_guid as fk_pgm,
				x4.c_guid as fk_rsk,
				ods.dbo.fn_bin2guid(_Fld7885RRef) as fk_ins,
				ods.dbo.fn_bin2guid(_RecorderRRef) as fk_reg,
				ods.dbo.fn_bin2guid(_Fld7885RRef) as fk_cnt
--				into #tmp1
	from STG.._InfoRg7879 t 
	cross apply ARC..fn_BIN2GUID(_Fld7880RRef) x1
	cross apply ARC..fn_BIN2GUID(_Fld7881RRef) x2
	cross apply ARC..fn_BIN2GUID(_Fld7882RRef) x3
	cross apply ARC..fn_BIN2GUID(_Fld7883RRef) x4