python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions