how to loop and insert records

Question

Post reply

how to loop and insert records

Patrick.I

Hall of Fame

Points: 3105
More actions
April 1, 2008 at 4:10 am

#188630

i have 3 tables like so below:
table -A
pid mid
--- ----
1 7
2 29
table -B
sid pid mid
--- --- ---
1 1 7
2 1 7
3 2 29
table -C
sid toy
--- ---
1 car
2 ball
3 toy phone
what i want is to loop through table A and C and add values sid,pid and mid into table -B
column sid,pid and mid in table -B isn't auto incremented
Any ideas and thanks in advance

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLZ SSChampion Points: 12872 More actions · Answer 1

Hi Patrick,

I'm not sure you'd need to use a loop. Would a cross join not work?

select sid, pid, mid

from testA, TestC

Karl
source control for SQL Server

Todd Engen SSCrazy Eights Points: 9869 More actions · Answer 2

In your example, what values did you use from table A and table C to generate table B?

shamshudheen SSCrazy Points: 2390 More actions · Answer 3

Patrick Ige (4/1/2008)
i have 3 tables like so below:
table -A
pid mid
--- ----
1 7
2 29
table -B
sid pid mid
--- --- ---
1 1 7
2 1 7
3 2 29
table -C
sid toy
--- ---
1 car
2 ball
3 toy phone
what i want is to loop through table A and C and add values sid,pid and mid into table -B
column sid,pid and mid in table -B isn't auto incremented
Any ideas and thanks in advance

Patrick,

what is the relation between A and C table

if you do cross join you will get cortesan product records. check your resulted table

shamsudheen

Patrick.I Hall of Fame Points: 3105 More actions · Answer 4

Patrick.I

Hall of Fame

Points: 3105

April 3, 2008 at 3:32 am

#797692

thanks guys all fixed using cross joins