create proc paid @USERNAME varchar, @prd_name int, @paid_amt int
as
insert into paidTABLE values (@USERNAME, @prd_name, @paid_amt  )

quote:

---

Originally posted by jonekim

I've 3 tables:
1. userTABLE
- USERNAME (jone)
2. productTABLE
- prd_name (prd1, prd2, prd3)
3. paidTABLE
- USERNAME
- prd_name
- paid_amt

My query is to insert amount paid by jone for the 3 products.
One way is: I've to seperately insert paid amts by jone for every product he buys.

create proc paid @USERNAME varchar, @prd_name int, @paid_amt int
as
insert into paidTABLE values (@USERNAME, @prd_name, @paid_amt  )

Is there any way to insert the value of paid_amt at once in the table by jone for the 3 products?

---