• Ah

    I figured out the solution after posting.

    insert into @temp(binaryField)

    select convert(varbinary(max), @result , 2)

    Thanks anyway Experts! 🙂