Convert integer to hex

CREATE FUNCTION ToHex(@value int)

RETURNS varchar(50)

AS

BEGIN

    DECLARE @seq char(16)

    DECLARE @result varchar(50)

    DECLARE @digit char(1)

    SET @seq = '0123456789ABCDEF'

    SET @result = SUBSTRING(@seq, (@value%16)+1, 1)

    WHILE @value > 0

    BEGIN

        SET @digit = SUBSTRING(@seq, ((@value/16)%16)+1, 1)

        SET @value = @value/16

        IF @value <> 0 SET @result = @digit + @result

    END

    RETURN @result

END

GO

--------------------------------------------------------

select dbo.ToHex(091)

select dbo.ToHex(12408441)

exec SP Data to store a variable in SQL Server

DECLARE @Output1 VARCHAR(100), Output2 VARCHAR(100)

CREATE TABLE #tmpTable
(
    OutputValue1 VARCHAR(100), OutputValue2 VARCHAR(100),
)
INSERT INTO #tmpTable (OutputValue1,OutputValue2)
EXEC dbo.sp_name

SELECT
    @Output = OutputValue1, Output2= OutputValue2
FROM 
    #tmpTable

DROP TABLE #tmpTable

print @Output1