if object_id('test') > 0  drop table dbo.test

create table dbo.test (
	master_id		int,
	Title			varchar(20),
	Forename		varchar(50),
	Surname			varchar(50),
	Address1		varchar(200),
	Address2		varchar(200),
	Address3		varchar(200),
	Address4		varchar(200),
	Town			varchar(100),
	County			varchar(100),
	Postcode		varchar(20),
	Hierarchy		int
	)

insert into dbo.test
select 75984,	'Mr',	'O',	'SQLady',		'6 Vivien Avenue Midsomer Norto',	'Midsomer Norton',	NULL, NULL, 'RADSTOCK',	NULL, 'BA6 2VG'	,2 union all	
select 76144,	'Mrs',	'N',	'Replacemento',	'56 Vivien Avenue Midsomer Nort',	'Midsomer Norton',	NULL, NULL, 'RADSTOCK',	NULL, 'BA6 2VG'	,2	

select * from dbo.test