create and drop temp table in sql server

Hello everyone, I am going to share the create and drop a temporary table query using SQL Server.

The Query detail as given below.

DECLARE @STRI VARCHAR(500) = '1.00'

CREATE TABLE #TEMP_TB (TGB VARCHAR(100))

WHILE LEN(@STRI) > 0

BEGIN

    DECLARE @TGB VARCHAR(100)

    IF CHARINDEX('.', @STRI) > 0

        SET  @TGB = SUBSTRING(@STRI, 0, CHARINDEX('.', @STRI))

    ELSE

        BEGIN

                     SET  @TGB = @STRI

                     SET @STRI = '.'

        END

               

       INSERT INTO  #TEMP_TB VALUES (@TGB)

       SET @STRI = REPLACE(@STRI, @TGB + '.' , '')

 END

SELECT TGB FROM #TEMP_TB ORDER BY TGB DESC

DROP TABLE  #TEMP_TB