Sales.vIndividualDemographics

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

Field Name	Type and Size
CustomerID	int NOT NULL
TotalPurchaseYTD	money(19,4) NULL
DateFirstPurchase	datetime NULL
BirthDate	datetime NULL
MaritalStatus	nvarchar(1) NULL
YearlyIncome	nvarchar(30) NULL
Gender	nvarchar(1) NULL
TotalChildren	int NULL
NumberChildrenAtHome	int NULL
Education	nvarchar(30) NULL
Occupation	nvarchar(30) NULL
HomeOwnerFlag	bit NULL
NumberCarsOwned	int NULL