Randomly Generate a List of Names - SQL Server

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()