loop through a table variable in tsql without using a cursor
Solutions on MaxInterview for loop through a table variable in tsql without using a cursor by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "loop through a table variable in tsql without using a cursor"
Valentino
02 May 2016
1Declare @Id int
2While (Select Count(*) From ATable Where Processed = 0) > 0
3Begin
4 Select Top 1 @Id = Id From ATable Where Processed = 0
5 --Do some processing here
6 Update ATable Set Processed = 1 Where Id = @Id
7End
8similar questions
for cursor plsqlsql server loop over queryoracle dynamic cursor for loop examplesql server select top 1 assign to variablet sql dynamic top n querynested case statement in sqlselect into table variablepl sql implicit cursorvariables in select statement in sql serversql transact create cursor with dynamic tablesdeclare table variable sql serversql server tutorial cursorpl sql cursorcursor procedure with python mssql get resultsql var that stores the number of lines changedoracle execute immediate cursor loop examplesql cursor exampletsql copy tablewhat is purpose of cursor in sqlsql cursort sql cursor tr your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful