SQL Server - Storing multiple decimal values in a column?
Posted
by cshah
on Stack Overflow
See other posts from Stack Overflow
or by cshah
Published on 2010-05-19T13:44:11Z
Indexed on
2010/05/19
14:00 UTC
Read the original article
Hit count: 254
I know storing multiple values in a column. Not a good idea.
It violates first normal form --- which states NO multi valued attributes. Normalize period...
I am using SQL Server 2005
I have a table that require to store lower limit and uppper limit for a measurement, think of it as a minimum and maximum speed limit... only problem is only 2 % out of hundread i need upper limit. I will only have data for lower limit.
I was thinking to store both values in a column (Sparse column introduces in 2008 so not for me)
Is there a way...? Not sure about XML..
© Stack Overflow or respective owner