Thank you but i need something like below

DECLARE @Max_MAC BINARY(8)

DECLARE @StartRange BINARY(8)

DECLARE @EndRange BINARY(8)

DECLARE @MAC_Address BINARY(8)

SET @StartRange = 0x00000004A500114B

SET @EndRange = 0x00000004A50F11FF

SELECT @Max_MAC = MAX(MAC_Address)

FROM MAC_Address

IF (@Max_Mac >= @StartRange and @Max_Mac < @EndRange)

begin

@Max_Mac = generate a higher macaddress

INSERT INTO MAC_Address(MAC_Address,Timestamp) VALUES (@MAX_MAC, getdate())

END

I do not know how I can count a number more to the MAcAdress I would like to become to a table with macadresses like

0x00000004A500114B

0x00000004A500114C

0x00000004A500114D

...