Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Fri Feb 7 08:46:00 CST 2003
hi Arthur, actually they won't. Those are static adjustments, and they are being changed once manth, so the whole table will be repopulated on the first wd of the month. however, i am still to see the format of the excel spreadsheet in which each month has its own column which I have to get (up till now they've been sending excel spreadsheets already with summed number of columns with different tabs for each entity), if I would see it, it would certainly make everything easier.. > IMO the 70-column approach is going to require a whole lot of code to > maintain, since the values appropriate to each column will have to move > as time passes, won't they? I.e. "< 6 Months" will be erroneous after > one day, along with all the other values. I can see creating a 70-column > query that reports the results the way management wants, since the same > algorithm can apply to all the columns regardless of the date. > > -----Original Message----- > From: accessd-admin at databaseadvisors.com > [mailto:accessd-admin at databaseadvisors.com] On Behalf Of > Oleg_123 at xuppa.com Sent: February 6, 2003 2:44 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Maximum number of columns in a table ? > > Charles, I ofcourse agree with Fransisco, and Jeff Putnam who wrote the > article. But that's how they want this, i was just checking if 70 > columns may caz problems, frankly I've never seen a table like that. I > am not running the company and I ca't really input my rules. > Right now they've decided to refernish the division I personally would > first paint the walls, then do the carpeting, then bring the new > furniture. They are doing this in exactly the opposite order, some of > the new furniture is already here, and painting doesn't start till > monday, and we'll still have to wear corparate attire. And we can't > really argue.. :) > > >> Oleg, >> >> If you want to be a spreadsheet developer and not a database >> developer, then continue with your spreadsheet thinking. But if you >> do want to be a database developer, please follow Francisco's advice. >> >> Charles Wortz >> Software Development Division >> Texas Education Agency >> 1701 N. Congress Ave >> Austin, TX 78701-1494 >> 512-463-9493 >> CWortz at tea.state.tx.us >> (SELECT * FROM users WHERE clue > 0) >> >> >> -----Original Message----- >> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] >> Sent: Thursday 2003 Feb 06 13:11 >> To: accessd at databaseadvisors.com >> Subject: Re: [AccessD] Maximum number of columns in a table ? >> Importance: Low >> >> >> Francisco, >> >> right now we have column fields 2m(onths) 3, 4-6, 7-12, >2y (years >> which is 13 - 24) and <2y (goes up to 30 years)) Now they want a field >> for each individual monts; I think that creating a table with roughtly >> 70 fields would be the most painless solution (and from it a query >> with original fields - 4-6, 7-12, and reling it as datasource for >> reports) >> >>> Oleg, >>> 70 fields? I recommend reviewing the benefits of normalization, >>> specifically BCNF which is a derived from 3NF >>> http://databasejournal.com/sqletc/article.php/1443021 >>> >>> more hits on google: >>> http://tinyurl.com/5g4v >>> >>> -Francisco >>> http://rcm.netfirms.com >>> ----- Original Message ----- >>> From: "Drew Wutka" <DWUTKA at marlow.com> >>> To: <accessd at databaseadvisors.com> >>> Sent: Wednesday, February 05, 2003 3:47 PM >>> Subject: RE: [AccessD] Maximum number of columns in a table ? >>> >>> >>> : I believe the number of fields in a table is 255....I am assuming >>> it's the : same for a query. >>> : >>> : Drew >>> : >>> : -----Original Message----- >>> : From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] >>> : Sent: Wednesday, February 05, 2003 1:44 PM >>> : To: accessd at databaseadvisors.com >>> : Subject: [AccessD] Maximum number of columns in a table ? >>> : >>> : >>> : I need to feet around 70, can I ? I found this on google, but >>> somehowi >>> : don't trust it; o limit on rows ?? >>> : ------------------------------------ >>> : >>> : Maximum number of rows per table No Limit >>> : >>> : Maximum number of tables per database No limit >>> : >>> : Maximum number of tablespaces per database 32767 >>> : >>> : Maximum number of devices 32767 >>> : >>> : Maximum storage capacity 70 TB >>> : >>> : Maximum row size (excluding BLOB & FO columns) 3992 bytes >>> : >>> : Maximum number of columns per table 252 >>> : >>> : Maximum number of columns per index 16 >>> : >>> : Maximum number of journal files per database 8 >>> : >>> : Maximum length of table/column name 18 bytes >>> : >>> : Maximum number of tables per join 31 >>> : >>> : Maximum number of savepoints per transaction 32 >>> : >>> : Maximum cache memory 2GB >>> : >>> : >>> : >>> : ----------------------------------------- >>> : Send a Xuppa Valentine to Your Sweetheart today! >>> : http://www.xuppa.com/greet/ >>> : >>> : >>> : _______________________________________________ >>> : AccessD mailing list >>> : AccessD at databaseadvisors.com >>> : http://databaseadvisors.com/mailman/listinfo/accessd >>> : Website: http://www.databaseadvisors.com >>> : _______________________________________________ >>> : AccessD mailing list >>> : AccessD at databaseadvisors.com >>> : http://databaseadvisors.com/mailman/listinfo/accessd >>> : Website: http://www.databaseadvisors.com >>> : >>> >>> >>> _______________________________________________ >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >> >> >> >> ----------------------------------------- >> Send a Xuppa Valentine to Your Sweetheart today! >> http://www.xuppa.com/greet/ >> >> >> _______________________________________________ >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> _______________________________________________ >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com > > > > ----------------------------------------- > Send a Xuppa Valentine to Your Sweetheart today! > http://www.xuppa.com/greet/ > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com ----------------------------------------- Send a Xuppa Valentine to Your Sweetheart today! http://www.xuppa.com/greet/