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

Filed under:
|
|

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

Related posts about t-sql

Related posts about sql