Breaking News: Grepper is joining You.com. Read the official announcement!

SQL loop

Perry Vries answered on December 23, 2022 Popularity 10/10 Helpfulness 2/10

answer SQL loop

related for loop in sql

SQL loop

Comment

-- SQL server  LOOP WITH LIST   +   WHILE

DECLARE @INPUT_LIST NVARCHAR(MAX) = '1,2, 3 ,,5'

DECLARE
 @VALUE NVARCHAR(MAX)
,@VALUE_INT INT
,@SPLITS INT
,@START INT	
,@END INT;


	SET @INPUT_LIST = REPLACE(REPLACE( @INPUT_LIST ,CHAR(13),''),CHAR(10),'');
	SET @SPLITS = (select len(@INPUT_LIST) - len(replace(@INPUT_LIST,',','')) +1)
	---------===========
	-- LOOP SPLITS
	SET @END =0;
	SET @INPUT_LIST = ','+ @INPUT_LIST +',';
	DECLARE CURSOR_LOOP_SPLITS CURSOR FOR

		SELECT NULL

		OPEN CURSOR_LOOP_SPLITS;
		FETCH NEXT FROM CURSOR_LOOP_SPLITS

		WHILE @SPLITS >0
		BEGIN 
		SET @SPLITS = @SPLITS -1;

		SET @START	= CHARINDEX(',',@INPUT_LIST,@END);
		SET @END 	= CHARINDEX(',',@INPUT_LIST,@START+1);

	SET @VALUE = TRIM( SUBSTRING(@INPUT_LIST,@START+1,@END-@START-1) );

    IF (@END-@START >1)
		BEGIN
        --+++++++++++++++###  START CODE  ###+++++++++++++++--
        
        SELECT @VALUE
        
        --SET @VALUE_INT = CONVERT(INT,@VALUE);
	    --SELECT @VALUE_INT

        --EXEC STOREDPROCEDURE @VALUE_INT

        --+++++++++++++++###  END CODE  ###+++++++++++++++--
        END

	FETCH NEXT FROM CURSOR_LOOP_SPLITS

	END;

	CLOSE CURSOR_LOOP_SPLITS;
	DEALLOCATE CURSOR_LOOP_SPLITS;
	--------==========





------------------------------------------------------------------------
-- WHILE LOOP

DECLARE @I INT = 0

WHILE @I < 5
BEGIN
    SET @I = @I + 1
    /* do some work */
    SELECT @I
END

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: list sql

Link to this answer
Share Copy Link

Contributed on Dec 23 2022

Perry Vries

0 Answers Avg Quality 2/10

Closely Related Answers

for loop in sql

Comment

DECLARE @i int = 0

WHILE @i < 20
BEGIN
    SET @i = @i + 1
    /* do some work */
END

Popularity 9/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: for-loop for-loo

Link to this answer
Share Copy Link

Contributed on Apr 26 2023

Nanu

0 Answers Avg Quality 2/10

SQL loop

Contents

More Related Answers

SQL loop

Closely Related Answers

for loop in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.