Representing objects and dates

  • Thread starter Thread starter reidarT
  • Start date Start date
R

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
 
reidarT said:
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?
Click to expand...

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...
 
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
 
reidarT said:
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.
Click to expand...

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.
 
reidarT said:
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
Click to expand...
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
 
Back
Top