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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.