USE AdventureWorksDW
GO

CREATE VIEW dbo.CustomersHistoryFillFromExample AS
SELECT TOP 100 [FirstName] + ' ' +[LastName] AS Name,[EmailAddress],[Age],
[MaritalStatus],[Gender],[TotalChildren],[NumberChildrenAtHome],[Education],
[Occupation],[YearlyIncome],[HouseOwnerFlag],[NumberCarsOwned],[TotalAmount]
FROM [dbo].[CustomersHistory]
UNION 
SELECT TOP 1000 [FirstName] + ' ' +[LastName] AS Name,[EmailAddress],[Age],
[MaritalStatus],[Gender],[TotalChildren],[NumberChildrenAtHome],[Education],
[Occupation],[YearlyIncome],[HouseOwnerFlag],[NumberCarsOwned],NULL
FROM [dbo].[CustomersHistory];
GO