Home Forums SQL Server 2005 T-SQL (SS2K5) Query to retrieve a column depending on variable value? RE: Query to retrieve a column depending on variable value?

  • If a sixth column/price gets added or a new product in the family, with 'price 5' rather than 'price5' you will miss data, have to keep maintaining the query. That is the tough part about working with a design that is not normalised.

    ----------------------------------------------------