Loops inside a stored procedure

Dev Shed Forums Sponsor:

Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here!

March 25th, 2004, 04:01 PM

Registered User

Join Date: Mar 2004

Posts: 16

Time spent in forums: 20 m 5 sec
Reputation Power: 0

Loops inside a stored procedure

I need to know how to loop through the results of a select inside a stored procedure and execute inserts. The following is the pseudo code.

Code:

for each row in table t1 {
  select the ID from t1
  insert the ID into table t2
}

Thanks.

Last edited by mark_thurston : March 25th, 2004 at 04:03 PM. Reason: formatting

March 25th, 2004, 04:57 PM

Contributing User

Join Date: Jan 2003

Location: Paris Uppland

Posts: 1,762

Time spent in forums: 2 Weeks 4 Days 4 h 29 m 45 sec
Reputation Power: 37

You don't need a loop

Code:

  insert into t2(id) select id from t1

March 26th, 2004, 10:09 AM

Registered User

Join Date: Mar 2004

Posts: 16

Time spent in forums: 20 m 5 sec
Reputation Power: 0

Loops inside a stored procedure

I guess that I over-simplified the code. In the loop I need to get a couple of fields from t1 and do a like command on them.

Code:

for each row in table t1 {
  select the t2.ID from t2 where t2.textValue like '%' + t1.textValue + '%'
  insert the t2.ID into table t3 
}

Sorry for the previous ambiguity.

March 26th, 2004, 10:54 AM

Contributing User

Join Date: Jan 2003

Location: Paris Uppland

Posts: 1,762

Time spent in forums: 2 Weeks 4 Days 4 h 29 m 45 sec
Reputation Power: 37

You don't need a loop

Code:

  insert into t3(id) select id from t2
   where exists (select * from t1
    where t2.textvalue like '%' + t1.textValue + '%')

Viewing: Dev Shed Forums > Databases > MS SQL Development > Loops inside a stored procedure

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump