SQL Server, can SQL Server store 10 pieces of information of item in a row? -
i'm wondering if sql server can store 10 pieces of information of item in row?
because want make table of date, item_name, quantity
but want make in row input 1 date (ex. 21 november 2014) have item name such (chicken, rabbit, cow) have quantity of (2, 4, 3)
can sql ??
if not, can recommend me, because want make daily report of items have sold on day , day before , on.
can understand meant? cause i'm not english.
you should this:
table dates: dateid date 1 21/11/2014 2 23/11/2014 table items: dateid name quantity 1 chicken 2 1 rabbit 4 1 cow 3 2 dinosaur 666
dates.dateid
should primary key and, depending on logic, perhaps identity (it autogenerates following id), , items.dateid
should have foreign key dates.dateid
.
more info normalization here.
Comments
Post a Comment