Merry Christmas 2015

• sipas

  Hall of Fame

  Points: 3828

  More actions

  December 30, 2015 at 5:34 am

  #1848709

  arnierowland (12/25/2015)

  ---

  Try this one:

  SELECT geometry::Parse('POLYGON((

  4 0, 0 0, 3 2, 1 2, 3 4, 1 4, 3 6, 2 6,

  4 8, 6 6, 5 6, 7 4, 5 4, 7 2, 5 2, 8 0, 4 0

  ))')

  UNION ALL

  SELECT geometry::Parse('POLYGON((

  2.5 0, 3 -1, 5 -1, 5.5 0, 2.5 0

  ))')

  UNION ALL

  SELECT geometry::Parse('POLYGON((

  4 7.5, 3.5 7.25, 3.6 7.9, 3.1 8.2, 3.8 8.2,

  4 8.9, 4.2 8.2, 4.9 8.2, 4.4 7.9, 4.5 7.25, 4 7.5

  ))')

  UNION ALL

  SELECT geometry::Point(

  RAND(CHECKSUM(NEWID())) * 5 +1.5,

  RAND(CHECKSUM(NEWID())) * 6, 0

  ).STBuffer(0.3)

  FROM master.dbo.spt_values

  WHERE type = 'P' AND number BETWEEN 1 AND 20;

  Very nice, thanks for that - Happy Christmas!

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  December 30, 2015 at 4:32 pm

  #1848868

  Awesome. Thanks for the nice Christmas Tree.

  Thanks.

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  January 4, 2016 at 4:43 am

  #1849164

  Great question!

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• bc_

  Hall of Fame

  Points: 3173

  More actions

  January 4, 2016 at 11:23 am

  #1849295

  +1

  [font="Arial Narrow"]bc[/font]