Re: Structure Help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 09/04/04 

Date: Sat, 4 Sep 2004 13:42:08 +0530

OK. I understand what you are talking about.
I'll suggest that you keep a table for each of them
and ask your users to use a common seperator.

So If somebody entered
Steve, Adam, Anith, Celko in the [PeopleWhoContributed]
field, you can enter them as four rows in the table. 

-- 
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Drew" <dlaing@NOswvtc.state.va.SPAMus> wrote in message
news:uKs5R%23ekEHA.1904@TK2MSFTNGP09.phx.gbl...
> See the problem is that this is a paper based solution now and I have to
> make it into a application.  This is a multipage ASP application for our
> intranet, so yes I do expect some of our users to use all the space they
> can.  It is more like a journal of the resident's life at the facility.
So
> you can see that space is gonna be needed.
>
> Drew
>
>
> "Roji. P. Thomas" <lazydragon@nowhere.com> wrote in message
> news:ORRj$2ekEHA.1252@TK2MSFTNGP14.phx.gbl...
> > Buddy,
> >
> >     Even the names suggest that this table is not normalized.
> >     You have
> >
> >     PeopleWhoContributed - Which I think is a list of people.
> >     CharacteristicsInPeople - Again a list
> >     A series of Importance column which is repetition,
> >     And why you make all the fields VARCHAR(5000)?
> >
> >     Do you really expect your user to type in 55000 characters in a form
?
> >
> >
> >
> > -- 
> > Roji. P. Thomas
> > Net Asset Management
> > https://www.netassetmanagement.com
> >
> >
> > "Drew" <dlaing@NOswvtc.state.va.SPAMus> wrote in message
> > news:%23uFc0WekEHA.2500@TK2MSFTNGP09.phx.gbl...
> > > I am developing an application that is currently done on paper only.
> This
> > > application is going to take 16 fields, which some of the fields are
> > pretty
> > > big.  My question is, would it be better to split this table into 3 or
4
> > > tables (to escape the 8000 character row limit) or to make some of
these
> > > fields TEXT fields?  From what I've come across about TEXT fields,
they
> > are
> > > a bad idea.  Here is my current table,
> > >
> > > [RegNo] [int] NOT NULL ,
> > > [PeopleWhoContributed] [varchar] (1500)
> > > [LikeAndAdmire] [varchar] (2000)
> > > [CharacteristicsInPeople] [varchar] (3000)
> > > [SuccessThisYear] [varchar] (3000)
> > > [MostImportant] [varchar] (5000)
> > > [SecondMostImportant] [varchar] (5000)
> > > [ThirdMostImportant] [varchar] (5000)
> > > [WhatGoodAt] [varchar] (3000)
> > > [WhatMakesSense] [varchar] (3000)
> > > [WhatDoesntMakeSense] [varchar] (3000)
> > > [VisionForFuture] [varchar] (5000)
> > > [DischargePlanSummary] [varchar] (3000)
> > > [WhatToKnowAndDoToKeepHealtySafe] [varchar] (5000)
> > > [WhatToKnowAndDoToLearnSuccess] [varchar] (5000)
> > > [HowCommunicates] [varchar] (4000)
> > >
> > > Thanks,
> > > Drew
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Structure Help
    ... CharacteristicsInPeople - Again a list ... Roji. ... P. Thomas ... "Drew" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Dynamic table name in query
    ... "Roji. ... P. Thomas" wrote in message ... >> Dynamic SQL, you could just explain your position or at least write the ... >>> You are trying to write a procedure without any cohesion at all. ...
    (microsoft.public.sqlserver.programming)
  • Re: searching with varying parameters
    ... "Roji. ... P. Thomas" wrote in message ... > Net Asset Management ... >> body, Search by attachment name, search if message has attachments). ...
    (microsoft.public.sqlserver.programming)
  • Re: DISTINCT and LEFT JOIN problem
    ... > "Roji. ... P. Thomas" wrote in message ... >>>>> SELECT DISTINCT resResourceID, resDateIn, resDateOut, empEmployeeID, ...
    (microsoft.public.sqlserver.programming)
  • Re: Output parameters
    ... > Set CmdParams = Nothing ... > "Roji. ... P. Thomas" wrote in message ... >> Net Asset Management ...
    (microsoft.public.sqlserver.programming)