SELECT * FROM
(
	SELECT
		DISTINCT TOP 10 dbo.DimPatient.PatientKey,
		dbo.DimPatient.GPPracticeCode,
		dbo.DimPatient.NHSNumber,
		LEFT(dbo.DimPatient.YearMonthBirth, 4) AS YearOfBirth,
		dbo.DimPatient.DateOfDeath,
		dbo.DimEthnicity.EthnicityDescription AS Ethnicity,
		dbo.DimPatient.GenderValue AS Gender,
		dbo.DimPatient.PostCode,
		dbo.DimPatient.RegisterDate,
		dbo.DimPatient.RegisterStatus,
		dbo.DimPatient.DeRegisterDate,
		dbo.DimPatient.DeRegisterReason,
		dbo.DimPatient.MaritalStatusCode,
		dbo.DimPatient.MosaicCode
	FROM
		dbo.DimPatient
		INNER JOIN dbo.DimEthnicity
			ON  dbo.DimPatient.EthnicityKey = dbo.DimEthnicity.EthnicityKey
) s
ORDER BY
	NEWID()