create function dbo.fnNumericToLSN
(
 @lsn numeric(25)
)
returns table
as
return (
 select
  convert(nvarchar(10), convert(varbinary(4), cast(@lsn / 1000000000000000 as int), 1), 2) + ':' +
  convert(nvarchar(10), convert(varbinary(4), cast((@lsn / 100000) % 10000000000 as int), 1), 2) + ':' +
  convert(nvarchar(10), convert(varbinary(2), cast(@lsn % 100000 as int), 1), 2) as lsn_as_string
);
go

select top (10)
 dbt.database_transaction_begin_lsn, lsn.lsn_as_string
from
 sys.dm_tran_database_transactions dbt cross apply
 dbo.fnNumericToLSN(dbt.database_transaction_begin_lsn) lsn
where
 dbt.database_transaction_begin_lsn is not null;
go

drop function dbo.fnNumericToLSN;
go