I've 3 tables:
- USERNAME (jone)
- prd_name (prd1, prd2, prd3)
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
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?