problem of insert multiple data into multiple table of sql

[choong1990]

How to insert multiple data into mssql without using loop?
i'm developing a clinic management system, while doctor may give few medicines to patient,therefo re i hope inside my database,the data will look like

|-----------------------------------|
|   RecordID  |  ItemID   |   Amount|
|-----------------------------------|
|      1      |     1     |    10   |
|      1      |     2     |    100  |
--------------------------------------

and now what i get is...

|-----------------------------------|
|   RecordID  |  ItemID   |   Amount|
|-----------------------------------|
|      1      |     1     |    10   |
|      2      |     2     |    100  |
--------------------------------------

because i'm using store procedure and needed loop to store all "ItemID" into sql.

+------------+     +-----------------+     
| record      |     | record_items    |     
+------------+     +-----------------+    
|RecordID(PK)|  >  | RecordID (FK)   |  
|PatientID   |     | ItemID          |     
|Precription |     | Amount          |
|VisitDate   |     +-----------------+
+------------+

this is my 2 tables, i hope when storing data ,the recordID will not increase based on how many ItemID inserted.

[C CSR]

This looks kinda like a:

For i = x to y

[C CSR]

Sorry, got cut off. Repeat:

for i = 1 to x
for j = 1 to y
next j
next y

Its called "nesting." The "i" represents the clientID and "j" is the number of entries for that clientID. This is just an example. Gracefully, its not a loop.

[C CSR]

Correction, it is actually a loop :), but I don't see any way around it.

[PsychoCoder]

This can technically be done without using a loop but it's going to be a lot more work on you. I suggest using a loop to accomplish this

[Èñìàèëëû]

íà bytes.com òóò áûëî ìíîãî êîììåíòîâ - êóäà âñå ïîäåâàëîñü? òàì áûëè è èíòåðåñíûå?