declare @i1 int = 1234
declare @i2 int = 5678
declare @i3 int = 9101
declare @i4 int = 1121

declare @vb1 varbinary(16) 
declare @vb2 varbinary(16) 

set @vb1 = CAST(@i1 as varbinary(16))
set @vb1 = @vb1 + CAST(@i2 as varbinary(16))
set @vb1 = @vb1 + CAST(@i3 as varbinary(16))
set @vb1 = @vb1 + CAST(@i4 as varbinary(16))

set @vb2 = CAST(REVERSE(CAST(@i1 as varbinary(16))) as varbinary(16))
set @vb2 = @vb2 + CAST(REVERSE(CAST(@i2 as varbinary(16))) as varbinary(16))
set @vb2 = @vb2 + CAST(REVERSE(CAST(@i3 as varbinary(16))) as varbinary(16))
set @vb2 = @vb2 + CAST(REVERSE(CAST(@i4 as varbinary(16))) as varbinary(16))

SELECT @vb1
SELECT @vb2

SELECT cast(substring(@vb1,1,4) as int)
	, cast(substring(@vb1,5,4) as int)
	, cast(substring(@vb1,9,4) as int)
	, cast(substring(@vb1,13,4) as int)

SELECT cast(cast(reverse(substring(@vb2,1,4)) as varbinary(4)) as int)
	, cast(cast(reverse(substring(@vb2,5,4)) as varbinary(4)) as int)
	, cast(cast(reverse(substring(@vb2,9,4)) as varbinary(4)) as int)
	, cast(cast(reverse(substring(@vb2,13,4)) as varbinary(4)) as int)

insert tbl_LotData(lotnumber, StartDTS, EndDTS,LotQuantity
,block0
,block1
...
)
values (@lotnumber, @startDTS,@endDTS,@LotQuantity,
cast(cast(reverse(substring(@block,1,4)) as varbinary(4)) as int)
, cast(cast(reverse(substring(@block,5,4)) as varbinary(4)) as int)
...
)