View: 'Sales.vIndividualDemographics', Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table.

Field NameType and Size
CustomerIDint NOT NULL
TotalPurchaseYTDmoney(19,4) NULL
DateFirstPurchasedatetime NULL
BirthDatedatetime NULL
MaritalStatusnvarchar(1) NULL
YearlyIncomenvarchar(30) NULL
Gendernvarchar(1) NULL
TotalChildrenint NULL
NumberChildrenAtHomeint NULL
Educationnvarchar(30) NULL
Occupationnvarchar(30) NULL
HomeOwnerFlagbit NULL
NumberCarsOwnedint NULL