thanks a lot for giving valuable suggestion

could you please explain me procedure to do such job?

thanks again !

hi

i have been created the product table for the selling of products.

so counted the total sum of like quantity from product table.

next i want to update the total sum of...

hi,

i want to update total sum of quantity not only quantity.

hello,

i have been already created a table "product"

and run a select query.

but i need update query for total sum(quantity) where productID=@productID and suppliername=@suppliername

where productID and suppliername is composite key

so plz...

hi everyone,

i did a query for obtain sum of total quantity for display in gridview like as;-

select productID,productname,suppliername,SUM(quantity)as quantity,unitprice from product group by

productID,productname,suppliername,unitprice;

next i need to update sum of total...

hi ramesh

i m sorry because i forgotten adding some information.

i have one addition column purchaseorderIDalong with other column in table product

which is also composite key like other composite key

next

i have...

hiiiii ramesh

thanx for answer

i will check it

hi thanx for for valuable reply.

actually what i need are explained here :-

i have a product table having column like as:

productID productname suppliername quantity...