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...