Representing objects and dates

reidarT

I want to show data objects as Y-axis (rows) and dates alng x-axis (fields)

Date 01.01.05 02.01.05 03.01.05 ...
Obj1 Free Free Occupied
Obj2 Free Occupied Free
Obj3 Occupied Free Occupied
....

I wouldn't like to make a table with Dates as fields ( I need more than 2
years ahead)
Is threr another way to solve this problem?
regards
reidarT

Nov 17 '05 #1

Subscribe Post Reply

1242

Jon Skeet [C# MVP]

reidarT <re****@eivon.no> wrote:

I want to show data objects as Y-axis (rows) and dates alng x-axis (fields)

Date 01.01.05 02.01.05 03.01.05 ...
Obj1 Free Free Occupied
Obj2 Free Occupied Free
Obj3 Occupied Free Occupied
...

I wouldn't like to make a table with Dates as fields ( I need more than 2
years ahead)
Is threr another way to solve this problem?

I'm not entirely sure what the problem is, but DateTime is the normal
way of representing dates and times, and there's nothing that stops
them from representing dates later than 2007...

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

Nov 17 '05 #2

reidarT

No, that is not what I ment.
If the table contains the following fields
Objekt
Date1
Date2
Dtae3
....
Date 750
it becomes incredably big and I dont think you can have more than 25 fields
in a table.
regards
reidarT
"Jon Skeet [C# MVP]" <sk***@pobox.com> skrev i melding
news:MP************************@msnews.microsoft.c om...

reidarT <re****@eivon.no> wrote:
I want to show data objects as Y-axis (rows) and dates alng x-axis
(fields)

Date 01.01.05 02.01.05 03.01.05 ...
Obj1 Free Free Occupied
Obj2 Free Occupied Free
Obj3 Occupied Free Occupied
...

I wouldn't like to make a table with Dates as fields ( I need more than 2
years ahead)
Is threr another way to solve this problem?

I'm not entirely sure what the problem is, but DateTime is the normal
way of representing dates and times, and there's nothing that stops
them from representing dates later than 2007...

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

Nov 17 '05 #3

Jon Skeet [C# MVP]

reidarT <re****@eivon.no> wrote:

No, that is not what I ment.
If the table contains the following fields
Objekt
Date1
Date2
Dtae3
...
Date 750
it becomes incredably big and I dont think you can have more than 25 fields
in a table.

You can definitely have more than 25 fields in a table. However, it
feels more like you want those to be rows rather than columns.

It's still unclear exactly what your question is, I'm afraid.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

Nov 17 '05 #4

John B

reidarT wrote:

I want to show data objects as Y-axis (rows) and dates alng x-axis (fields)

Date 01.01.05 02.01.05 03.01.05 ...
Obj1 Free Free Occupied
Obj2 Free Occupied Free
Obj3 Occupied Free Occupied
...

I wouldn't like to make a table with Dates as fields ( I need more than 2
years ahead)
Is threr another way to solve this problem?
regards
reidarT

How about an 'objects' table with the object id etc..
and a 'dates' table with the date id etc..

then a joining table to say these are in use or free or whatever.
ie
Objects
Id Name
1 Obj1
2 Obj2

Dates
Id DateValue
1 2005-01-01
2 2005-01-02

FreeDates (different implementations could easily be done)
ObjectsId DatesId
1 1
1 2
2 1
in this scenario, object 2 is NOT free on 2005-01-02

HTH

JB

PS. you can have up to 1024 cols in an sql server 2000 db IIRC

Nov 17 '05 #5

Similar topics

Representing ambiguity in datetime?

by: Terry Hancock | last post by:

What do you do when a date or time is incompletely specified? ISTM, that as it is, there is no formal way to store this --- you have to guess, and there's no way to indicate that the guess is...

Python

Representing 8.5x11 in HTML

by: Dave | last post by:

I would like to create a table in HTML that represents a letter on a standard size sheet of paper. But of course, smaller so the width fits on the screen. How do I code an HTML table to...

HTML / CSS

passing objects in a collection as ref

by: jeff | last post by:

I have a collection of objects, call them MyObject, that I store in a Hashtable , myHashTable(with dates as keys for instance). These are VERY large objects and I have functions that take them as...

C# / C Sharp

Nulls and Database objects

by: tshad | last post by:

I have people telling me that I should set up objects for my tables, but I am finding the Null problem makes that difficult. It isn't a big problem if you are not updating the table, but if you...

C# / C Sharp

XBRL - representing a table

by: Greg | last post by:

Hi, I need to implement a table in XBRL. Let's assume I have 2 simple tables to define: TABLE 1 col1 col2 row1 A C row2 B D TABLE 2

.NET Framework

are there any dangers in storing objects in vectors?

by: r.z. | last post by:

I logged construtor and destructor calls for one of my classes and I discovered that the constructor was called only once while the destructor was called 3 times for a single object. I have a...

C / C++

representing rational numbers using java objects

by: penny | last post by:

In this assignment we shall look at a possible representation of rational numbers in java using objects. The java language represents rational numbers using the same representation used for other...

Java

Announcing: ACM SIGAPL apl 2007 -- Arrays and Objects

by: Mike Kent | last post by:

The APL 2007 conference, sponsored by ACM SIGAPL, has as its principal theme "Arrays and Objects" and, appropriately, is co-located with OOPSLA 2007, in Montreal this October. APL 2007 starts...

Python

"static" objects and functions

by: Jess | last post by:

Hello, I learned that there are five kinds of static objects, namely 1. global objects 2. object defined in namespace scope 3. object declared static instead classes 4. objects declared...

C / C++

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing