How to use Cursor to Execute stored procedure where featurevalue is b?

ahmed elbarbary

5y782

How to use Cursor to Execute stored procedure where featurevalue is bigger than 0 ?

I work on SQL server 2012 . I face issue I can't use cursor to execute stored procedure when feature value is bigger than 0 .

I have stored procedure must execute with every line where feature value is bigger than 0

so according to my case I will use cursor to execute stored procedure with feature value that bigger than 0

so EXEC sp_updatevaluesonTables 10,30,40,50

this sp pass to it feature value to do some thing update and insert data

so How to use cursor to execute stored procedure sp_updatevaluesonTables with every value bigger than 0

cursor

EXEC sp_updatevaluesonTables 10,30,40,50

end cursor

im not use cursor before so can you help me

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
create table #updatestatus
(
FeatureValue int,
status nvarchar(50)
)
insert into #updatestatus
values
(10,NULL),
(50,NULL),
(-2,NULL),
(-3,NULL),
(30,NULL),
(40,NULL)

-- declare variables and
-- cursor for feature value bigger than 0
DECLARE @featureValue int
DECLARE cursor_feature CURSOR
FOR SELECT FeatureValue FROM #updatestatus WHERE FeatureValue > 0;

-- open cursor
OPEN cursor_feature;

-- initially fetch a row of value
FETCH NEXT  FROM cursor_feature INTO @featureValue

-- if fetch action is successful, do something using this result
-- then fetch for next loop
WHILE @@FETCH_STATUS = 0
BEGIN
    -- you might want to use @featureValue with your stored procedure
    PRINT @featureValue
    FETCH NEXT FROM cursor_feature INTO @featureValue
    END

    CLOSE cursor_feature
    DEALLOCATE cursor_feature
Output:
(6 row(s) affected)

10
50
30
40
Sachin Singh5y ago
go through this article to understand cursor
https://www.aspsnippets.com/Articles/Using-Cursor-in-SQL-Server-Stored-Procedure-with-example.aspx