Abdulftah Alkhraz Abdulftah Alkhraz - 1 year ago 67
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

Answer Source

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.