create and insert into temp table in sql server

Create and insert into temp table in sql server


DECLARE @S VARCHAR(8000), @Split CHAR(1), @leng BIGINT,
                  @percoll VARCHAR(8000), @cnt BIGINT
        
SET @Str = '4,5,6,7'            
SET @Split =','
SET @leng = (SELECT COUNT(*) FROM dbo.SplitString(@Str, @Split))

DECLARE @temp TABLE
(
  ID BIGINT IDENTITY(1,1), RoleID BIGINT, count INT
)

INSERT INTO @temp
                SELECT * FROM (
                                SELECT RoleID, COUNT(*) AS [Count] FROM [dbo].[TBL_Role] GROUP BY RoleID
                                ) AS INNERTABLE
                WHERE [count] = @leng

SET @cnt = (SELECT COUNT(*) FROM @temp)

IF(@cnt > 0)
BEGIN
      WHILE(@cnt > 0)
                BEGIN
                      SELECT * FROM [TBL_Role] WHERE RoleID = (SELECT RoleID FROM @temp WHERE ID = @cnt)
                      SET @cnt = @cnt - 1
                END
END


ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^