Click here to Skip to main content
15,918,617 members
Home / Discussions / Database
   

Database

 
AnswerRe: @@ parameter Pin
M LN Rao9-Oct-07 20:56
M LN Rao9-Oct-07 20:56 
AnswerRe: @@ parameter Pin
joemonvarghese9-Oct-07 22:49
joemonvarghese9-Oct-07 22:49 
Questionfor loop in stored procedure Pin
Sonia Gupta8-Oct-07 23:35
Sonia Gupta8-Oct-07 23:35 
AnswerRe: for loop in stored procedure Pin
Colin Angus Mackay9-Oct-07 0:09
Colin Angus Mackay9-Oct-07 0:09 
GeneralRe: for loop in stored procedure Pin
Sonia Gupta9-Oct-07 0:32
Sonia Gupta9-Oct-07 0:32 
GeneralRe: for loop in stored procedure Pin
Sonia Gupta9-Oct-07 0:51
Sonia Gupta9-Oct-07 0:51 
GeneralRe: for loop in stored procedure Pin
Krish - KP9-Oct-07 0:58
Krish - KP9-Oct-07 0:58 
GeneralRe: for loop in stored procedure Pin
GuyThiebaut9-Oct-07 1:05
professionalGuyThiebaut9-Oct-07 1:05 
You may have to use a cursor.

This depends on what you are doing in the loop.
A cursor will let you process each row of a query individually.
If you google "SQL cursor" you will find lots of examples.

Regards

Guy


You always pass failure on the way to success.

GeneralRe: for loop in stored procedure Pin
Colin Angus Mackay9-Oct-07 2:14
Colin Angus Mackay9-Oct-07 2:14 
GeneralRe: for loop in stored procedure Pin
GuyThiebaut9-Oct-07 2:22
professionalGuyThiebaut9-Oct-07 2:22 
GeneralRe: for loop in stored procedure Pin
Colin Angus Mackay9-Oct-07 3:00
Colin Angus Mackay9-Oct-07 3:00 
GeneralRe: for loop in stored procedure Pin
GuyThiebaut9-Oct-07 3:16
professionalGuyThiebaut9-Oct-07 3:16 
AnswerRe: for loop in stored procedure Pin
Christian Graus9-Oct-07 14:39
protectorChristian Graus9-Oct-07 14:39 
QuestionStoring RTF in SQL Pin
MartyK20078-Oct-07 22:47
MartyK20078-Oct-07 22:47 
AnswerRe: Storing RTF in SQL Pin
Colin Angus Mackay9-Oct-07 0:13
Colin Angus Mackay9-Oct-07 0:13 
GeneralRe: Storing RTF in SQL Pin
MartyK20079-Oct-07 0:39
MartyK20079-Oct-07 0:39 
GeneralRe: Storing RTF in SQL Pin
MartyK20079-Oct-07 1:05
MartyK20079-Oct-07 1:05 
QuestionCreating Virtual Directories in Reporting Services Pin
Karuna Kumar8-Oct-07 20:44
Karuna Kumar8-Oct-07 20:44 
AnswerRe: Creating Virtual Directories in Reporting Services [modified] Pin
John Gathogo8-Oct-07 23:18
John Gathogo8-Oct-07 23:18 
QuestionJoining 2 Tables Pin
Brendan Vogt8-Oct-07 20:22
Brendan Vogt8-Oct-07 20:22 
AnswerRe: Joining 2 Tables Pin
Krish - KP8-Oct-07 21:09
Krish - KP8-Oct-07 21:09 
QuestionSQL 2005 SQL Profiler? Pin
devvvy8-Oct-07 16:35
devvvy8-Oct-07 16:35 
Answerfound one --- Re: SQL 2005 SQL Profiler? Pin
devvvy8-Oct-07 18:41
devvvy8-Oct-07 18:41 
QuestionIntermittent errors..please help!!! Pin
new_phoenix8-Oct-07 10:51
new_phoenix8-Oct-07 10:51 
AnswerRe: Intermittent errors..please help!!! Pin
andyharman9-Oct-07 1:30
professionalandyharman9-Oct-07 1:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.