I looked for a way of modifying the original, but couldn't find it, so I'll just make it available here.

CREATE TABLE [db].[table1] (

[columnA] [numeric](18, 0) NOT NULL ,

[columnb] [ntext] COLLATE Latin1_General_CI_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

INSERT [db].[table1] VALUES (1, 'Michael.Jordan@domain.com')

INSERT [db].[table1] VALUES (2, 'Red')

INSERT [db].[table1] VALUES (3, 'Lebron.James@domain.com')

INSERT [db].[table1] VALUES (4, 'Black')

INSERT [db].[table1] VALUES (5, 'Kobe.Bryant@domain.com')

INSERT [db].[table1] VALUES (6, 'Purple')

INSERT [db].[table1] VALUES (7, 'Earvin.Johnson@domain.com')

INSERT [db].[table1] VALUES (8, 'Yellow')

INSERT [db].[table1] VALUES (9, 'Charles.Barkely@domain.com')

INSERT [db].[table1] VALUES (10, 'White')

GO

CREATE TABLE [db].[table2] (

[columnA] [numeric](18, 0) NOT NULL ,

[columnb] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL ,

[columnc] [numeric](18, 0) NULL ,

[columnd] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL ,

[columne] [int] NULL

) ON [PRIMARY]

INSERT [db].[table2] VALUES (1, 'properties', 1, 'email', 5)

INSERT [db].[table2] VALUES (2, 'properties', 1, 'clubcolour', 5)

INSERT [db].[table2] VALUES (3, 'properties', 1, 'email', 5)

INSERT [db].[table2] VALUES (4, 'properties', 1, 'clubcolour', 5)

INSERT [db].[table2] VALUES (5, 'properties', 1, 'email', 5)

INSERT [db].[table2] VALUES (6, 'properties', 1, 'clubcolour', 5)

INSERT [db].[table2] VALUES (7, 'properties', 1, 'email', 5)

INSERT [db].[table2] VALUES (8, 'properties', 1, 'clubcolour', 5)

INSERT [db].[table2] VALUES (9, 'properties', 1, 'email', 5)

INSERT [db].[table2] VALUES (10, 'properties', 1, 'clubcolour', 5)

GO