T-SQL "Random" Password "Generation"

In case you've ever wondered how cool random passwords like "rug1wh9p" are generated, you probably won't get much satisfaction from Alfred Whitehead's coworker's code. Actually, he shows you a great way *not* to generate random passwords. It is creative though. For extra fun, try guessing how many rows this will return without running the query.

INSERT INTO 
dbo.attendee_users (password)
SELECT a.A + b.B + c.C + d.D AS Password
FROM 
  (SELECT 'a' AS A
   UNION
   SELECT 'r'
   UNION
   SELECT 'i') a 
 CROSS JOIN
  (SELECT '5' AS B
   UNION
   SELECT '2'
   UNION
   SELECT '19'
   UNION
   SELECT '4'
   UNION
   SELECT '87a3') b 
 CROSS JOIN
  (SELECT 'vgh' AS C
   UNION
   SELECT '8R7y') c 
 CROSS JOIN
  (SELECT '6' AS D
   UNION
   SELECT '7'
   UNION
   SELECT '8'
   UNION
   SELECT '9'
   UNION
   SELECT '1') d