Your technology certification is waiting. Enroll in Cloud Class ®
WHILE @x <= 6
select @Intgr = t from @Arr where i = @x
if @Intgr > 0
UPDATE @Arr SET t = 1 WHERE i = 0
UPDATE @Arr SET t = (select t from @ArrValues where i = @x) WHERE i = 1
UPDATE @Arr SET t = (select t2 from @ArrValues where i = @x) WHERE i = 2
set @bFlag = 0
Declare @j as int
SET @j = 0
declare @u as int
select @u = t2 from @Arr where i = 6 --UBOUND array is 6
WHILE @j < @u
DECLARE @COMP1 AS INT
DECLARE @COMP2 as INT
SELECT @COMP1 = dbo.GetStringingSupport(@j) from @arr where i = 1
END --while nested
Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.