Abdulftah Alkhraz Abdulftah Alkhraz - 7 months ago 31
SQL Question

How To insert more than one value into one filed using SQL Server

I need to insert more than one value in Fields (SellPrice1,SellPirce2)
Because maybe one Of Item have 2 or 3 Sell Price.

enter image description here


You could either add an [ItemSalePrice3] column, but that could go on for ever, and you usually don't want your DB to grow horizontally instead of vertically.

I would personally add a table like:

item_id    price
1          1,50
1          2,00
2          4,00

And add an entry to that table for each price an item has.