Re: how to use a variable into a select?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/08/04 

Date: Mon, 8 Nov 2004 10:15:39 -0500

> The table "day" contains 6 fields: 5 fields ("monday", "tuesday"
> ..."friday") and 1 field ("hour"). The field "hour" conatins the opening
> hours of the day ("8.00-9.00", "9.00-10.00" etc till "17.00-18.00").
> The table contains 10 records.
> Each field ("monday", "tuesday" ...) contains for each hour "Yes" or "NO"
> (open or not).

Pardon me for saying so, but this is terrible design, IMHO. If you decide
to open on Saturdays, now you have to add a column to the table? Ugh.
Monday, Tuesday etc. are data, not data descriptors. That data should be in
a single column, not indicated in multiple columns.

A

Relevant Pages

  • Re: PROJECT PROBLEMS
    ... and pardon, what do you mean of saying ... am i going to use a filter method? ... >>> to make the story shorter, i am doing this reverberation meter ...
    (comp.soft-sys.matlab)
  • Re: PROJECT PROBLEMS
    ... and pardon, what do you mean of saying ... Start writing ... MATLAB code to do the processing you want and post here when you get stuck. ...
    (comp.soft-sys.matlab)
  • Re: Once again on the use of the follow-on
    ... Yet Fran was standin' in the doorway ... Pardon? ... What the Hell is data if it isn't ...
    (rec.sport.cricket)
  • Re: Once again on the use of the follow-on
    ... Yet Fran was standin' in the doorway ... Pardon? ...
    (rec.sport.cricket)
  • Re: misconceptions on computer science
    ... > Every now and then someone comes out saying that the TT is idiotic - ... > pardon, not valid. ... Pheraps, doing so boosts the someone's ego ("hey look, ... If you can't imagine ...
    (comp.object)