with FirstName as ( select s = 'James', Gender='M' union select 'John', 'M' union select 'Robert', 'M' union select 'Michael', 'M' union select 'William', 'M' union select 'David', 'M' union select 'Richard', 'M' union select 'Charles', 'M' union select 'Joseph', 'M' union select 'Thomas', 'M' union select 'Christopher', 'M' union select 'Daniel', 'M' union select 'Paul', 'M' union select 'Mark', 'M' union select 'Donald', 'M' union select 'George', 'M' union select 'Kenneth', 'M' union select 'Steven', 'M' union select 'Edward', 'M' union select 'Brian', 'M' union select 'Ronald', 'M' union select 'Anthony', 'M' union select 'Kevin', 'M' union select 'Jason', 'M' union select 'Matthew', 'M' union select 'Gary', 'M' union select 'Timothy', 'M' union select 'Jose', 'M' union select 'Larry', 'M' union select 'Jeffrey', 'M' union select 'Frank', 'M' union select 'Scott', 'M' union select 'Eric', 'M' union select 'Stephen', 'M' union select 'Andrew', 'M' union select 'Raymond', 'M' union select 'Gregory', 'M' union select 'Joshua', 'M' union select 'Jerry', 'M' union select 'Dennis', 'M' union select 'Walter', 'M' union select 'Patrick', 'M' union select 'Peter', 'M' union select 'Harold', 'M' union select 'Douglas', 'M' union select 'Henry', 'M' union select 'Carl', 'M' union select 'Arthur', 'M' union select 'Ryan', 'M' union select 'Roger', 'M' union select 'Mary', 'F' union select 'Patricia', 'F' union select 'Linda', 'F' union select 'Barbara', 'F' union select 'Elizabeth', 'F' union select 'Jennifer', 'F' union select 'Maria', 'F' union select 'Susan', 'F' union select 'Margaret', 'F' union select 'Dorothy', 'F' union select 'Lisa', 'F' union select 'Nancy', 'F' union select 'Karen', 'F' union select 'Betty', 'F' union select 'Helen', 'F' union select 'Sandra', 'F' union select 'Donna', 'F' union select 'Carol', 'F' union select 'Ruth', 'F' union select 'Sharon', 'F' union select 'Michelle', 'F' union select 'Laura', 'F' union select 'Sarah', 'F' union select 'Kimberly', 'F' union select 'Deborah', 'F' union select 'Jessica', 'F' union select 'Shirley', 'F' union select 'Cynthia', 'F' union select 'Angela', 'F' union select 'Melissa', 'F' union select 'Brenda', 'F' union select 'Amy', 'F' union select 'Anna', 'F' union select 'Rebecca', 'F' union select 'Virginia', 'F' union select 'Kathleen', 'F' union select 'Pamela', 'F' union select 'Martha', 'F' union select 'Debra', 'F' union select 'Amanda', 'F' union select 'Stephanie', 'F' union select 'Carolyn', 'F' union select 'Christine', 'F' union select 'Marie', 'F' union select 'Janet', 'F' union select 'Catherine', 'F' union select 'Frances', 'F' union select 'Ann', 'F' union select 'Joyce', 'F' union select 'Diane', 'F' ) ,LastName as ( select s = 'Smith' union select 'Johnson' union select 'Williams' union select 'Brown' union select 'Jones' union select 'Miller' union select 'Davis' union select 'Garcia' union select 'Rodriguez' union select 'Wilson' union select 'Martinez' union select 'Anderson' union select 'Taylor' union select 'Thomas' union select 'Hernandez' union select 'Moore' union select 'Martin' union select 'Jackson' union select 'Thompson' union select 'White' union select 'Lopez' union select 'Lee' union select 'Gonzalez' union select 'Harris' union select 'Clark' union select 'Lewis' union select 'Robinson' union select 'Walker' union select 'Perez' union select 'Hall' union select 'Young' union select 'Allen' union select 'Sanchez' union select 'Wright' union select 'King' union select 'Scott' union select 'Green' union select 'Baker' union select 'Adams' union select 'Nelson' union select 'Hill' union select 'Ramirez' union select 'Campbell' union select 'Mitchell' union select 'Roberts' union select 'Carter' union select 'Phillips' union select 'Evans' union select 'Turner' union select 'Torres' union select 'Parker' union select 'Collins' union select 'Edwards' union select 'Stewart' union select 'Flores' union select 'Morris' union select 'Nguyen' union select 'Murphy' union select 'Rivera' union select 'Cook' union select 'Rogers' union select 'Morgan' union select 'Peterson' union select 'Cooper' union select 'Reed' union select 'Bailey' union select 'Bell' union select 'Gomez' union select 'Kelly' union select 'Howard' union select 'Ward' union select 'Cox' union select 'Diaz' union select 'Richardson' union select 'Wood' union select 'Watson' union select 'Brooks' union select 'Bennett' union select 'Gray' union select 'James' union select 'Reyes' union select 'Cruz' union select 'Hughes' union select 'Price' union select 'Myers' union select 'Long' union select 'Foster' union select 'Sanders' union select 'Ross' union select 'Morales' union select 'Powell' union select 'Sullivan' union select 'Russell' union select 'Ortiz' union select 'Jenkins' union select 'Gutierrez' union select 'Perry' union select 'Butler' union select 'Barnes' union select 'Fisher' ) select top 100 FirstName = FirstName.s ,LastName = LastName.s ,FirstName.Gender from FirstName ,LastName order by NEWID()