how to put different amount and weight for one product

Question

how to put different amount and weight for one productname in sql server..

example

product name weight price

closeup 25kg 15

50kg 30

75 45

i need product name one time ..but need to enter weight and price.....

Iftikar Hussain · Answer

Hi, In SQL you can't do exactly same. But you can save child table to maintain weight and price. In Parent Table ProductInfo -------------- ProductId ProductName 1 closeup 2 cinthol in child table ProductWeightInfo ------------------- ProductId UniqueId Weight Price 1 1 25KG 15 1 2 50KG 30 aaa

Sanjeeb Lenka · Answer

As of my knowledge you can't do it in sql server. but in front end you can show like this.

Sivaraman Dhamodaran · Answer

Doing so you will face some problem. In your above example, you don't have product name for two records. OK. Let us say you have two more records like: product name weight price Colgate 50 Kg 45 100 Kg 80 Now you have 5 records in total. How do you differentiate the records that don't have a name (3 such exists now).

how to put different amount and weight for one product

Answers (3)