Comments by Member 10664091 (Top 2 by date)

Only options is given to generate at db level can not re deploy application following is my code if you can help.

DECLARE @input VARCHAR(50)
SET @input = '0002020102110202000424PK33HABB00044979013914031004'

SET NOCOUNT ON
DECLARE @tblLookup TABLE (ID INT IDENTITY(0,1) NOT NULL, Value BIGINT)
--INSERT INTO @tblLookup VALUES (0)
INSERT INTO @tblLookup VALUES (0x0000)
INSERT INTO @tblLookup VALUES (0x1021)
INSERT INTO @tblLookup VALUES (0x2042)
INSERT INTO @tblLookup VALUES (0x3063)
INSERT INTO @tblLookup VALUES (0x4084)
INSERT INTO @tblLookup VALUES (0x50A5)
INSERT INTO @tblLookup VALUES (0x60C6)
INSERT INTO @tblLookup VALUES (0x70E7)
INSERT INTO @tblLookup VALUES (0x8108)
INSERT INTO @tblLookup VALUES (0x9129)
INSERT INTO @tblLookup VALUES (0xA14A)
INSERT INTO @tblLookup VALUES (0xB16B)
INSERT INTO @tblLookup VALUES (0xC18C)
INSERT INTO @tblLookup VALUES (0xD1AD)
INSERT INTO @tblLookup VALUES (0xE1CE)
INSERT INTO @tblLookup VALUES (0xF1EF)
INSERT INTO @tblLookup VALUES (0x1231)
INSERT INTO @tblLookup VALUES (0x0210)
INSERT INTO @tblLookup VALUES (0x3273)
INSERT INTO @tblLookup VALUES (0x2252)
INSERT INTO @tblLookup VALUES (0x52B5)
INSERT INTO @tblLookup VALUES (0x4294)
INSERT INTO @tblLookup VALUES (0x72F7)
INSERT INTO @tblLookup VALUES (0x62D6)
INSERT INTO @tblLookup VALUES (0x9339)
INSERT INTO @tblLookup VALUES (0x8318)
INSERT INTO @tblLookup VALUES (0xB37B)
INSERT INTO @tblLookup VALUES (0xA35A)
INSERT INTO @tblLookup VALUES (0xD3BD)
INSERT INTO @tblLookup VALUES (0xC39C)
INSERT INTO @tblLookup VALUES (0xF3FF)
INSERT INTO @tblLookup VALUES (0xE3DE)
INSERT INTO @tblLookup VALUES (0x2462)
INSERT INTO @tblLookup VALUES (0x3443)
INSERT INTO @tblLookup VALUES (0x0420)
INSERT INTO @tblLookup VALUES (0x1401)
INSERT INTO @tblLookup VALUES (0x64E6)
INSERT INTO @tblLookup VALUES (0x74C7)
INSERT INTO @tblLookup VALUES (0x44A4)
INSERT INTO @tblLookup VALUES (0x5485)
INSERT INTO @tblLookup VALUES (0xA56A)
INSERT INTO @tblLookup VALUES (0xB54B)
INSERT INTO @tblLookup VALUES (0x8528)
INSERT INTO @tblLookup VALUES (0x9509)
INSERT INTO @tblLookup VALUES (0xE5EE)
INSERT INTO @tblLookup VALUES (0xF5CF)
INSERT INTO @tblLookup VALUES (0xC5AC)
INSERT INTO @tblLookup VALUES (0xD58D)
INSERT INTO @tblLookup VALUES (0x3653)
INSERT INTO @tblLookup VALUES (0x2672)
INSERT INTO @tblLookup VALUES (0x1611)
INSERT INTO @tblLookup VALUES (0x0630)
INSERT INTO @tblLookup VALUES (0x76D7)
INSERT INTO @tblLookup VALUES (0x66F6)
INSERT INTO @tblLookup VALUES (0x5695)
INSERT INTO @tblLookup VALUES (0x46B4)
INSERT INTO @tblLookup VALUES (0xB75B)
INSERT INTO @tblLookup VALUES (0xA77A)
INSERT INTO @tblLookup VALUES (0x9719)
INSERT INTO @tblLookup VALUES (0x8738)
INSERT INTO @tblLookup VALUES (0xF7DF)
INSERT INTO @tblLookup VALUES (0xE7FE)
INSERT INTO @tblLookup VALUES (0xD79D)
INSERT INTO @tblLookup VALUES (0xC7BC)
INSERT INTO @tblLookup VALUES (0x48C4)
INSERT INTO @tblLookup VALUES (0x58E5)
INSERT INTO @tblLookup VALUES (0x6886)
INSERT INTO @tblLookup VALUES (0x78A7)
INSERT INTO @tblLookup VALUES (0x0840)
INSERT INTO @tblLookup VALUES (0x1861)
INSERT INTO @tblLookup VALUES (0x2802)
INSERT INTO @tblLookup VALUES (0x3823)
INSERT INTO @tblLookup VALUES (0xC9CC)
INSERT INTO @tblLookup VALUES (0xD9ED)
INSERT INTO @tblLookup VALUES (0xE98E)
INSERT INTO @tblLookup VALUES (0xF9AF)
INSERT INTO @tblLookup VALUES (0x8948)
INSERT INTO @tblLookup VALUES (0x9969)
INSERT INTO @tblLookup VALUES (0xA90A)
INSERT INTO @tblLookup VALUES (0xB92B)
INSERT INTO @tblLookup VALUES (0x5AF5)
INSERT INTO @tblLookup VALUES (0x4AD4)
INSERT INTO @tblLookup VALUES (0x7AB7)
INSERT INTO @tblLookup VALUES (0x6A96)
INSERT INTO @tblLookup VALUES (0x1A71)
INSERT INTO @tblLookup VALUES (0x0A50)
INSERT INTO @tblLookup VALUES (0x3A33)
INSERT INTO @tblLookup VALUES (0x2A12)
INSERT INTO @tblLookup VALUES (0xDBFD)
INSERT INTO @tblLookup VALUES (0xCBDC)
INSERT INTO @tblLookup VALUES (0xFBBF)
INSERT INTO @tblLooku