i’m looking for the word that is used to describe the following.

I have a table with columns:
-WeekNumber
-Cost (total cost per week)

I have changed the table def to be:
-WeekNumber
-DayOfWeek
-Cost (Total cost per day)

Effectively i have increased the level of detail of each record. What is the correct term for this? Cardinality comes to mind but i just googled it and I don’t think its correct.

It’s kind of rationalisation. Ish.
But I’d be splitting it into another table.

Granularity?

Granularity?

Edit: gah beaten by 8 seconds 🙂

Jinx!

Granularity – I’ll have that!

But I’d be splitting it into another table.

Ok instead of table – I actually meant recordset otherwise a new table would have been on the cards.

Thanks all.

But I’d be splitting it into another table.

Why?

what sort of data types are weeknumber and dayofweek and how are they to be used

I’m asking as I don’t understand your reqts(or the facilities you have) so the following might be tosh but using date types might make more sense if you want to query/sort/order/group etc the data based on date type criteria.

Depends on who you communicate this to… could also be termed a random act of sabotage depending on who consumes the row 🙂