Hi,

You can reduce the space similarly without XML. You can use the table instead of the XML column.

CREATE TABLE Rainfall_LocDate

(LocDateId int IDENTITY(1, 1)

,LocID int

,Date datetime

,CONSTRAINT PK_Rainfall_LocDate PRIMARY KEY NONCLUSTERED(LocID,Date)

)

CREATE TABLE Rainfall_Data

(LocDateId int

,Hour tinyint

,Rainfall numeric(10,8)

,CONSTRAINT PK_Rainfall_Data PRIMARY KEY NONCLUSTERED(LocDId,Hour)

)

Regards,

Pavel Krticka