SQL: Select points that fall within a polygon

SelectPointsWithinPolygon.sql

-- SQL Server 2008R2, there are better functions in later versions of Sql Server such as STContains()
SELECT Animals.GroupNumber
FROM LegacyUnits INNER JOIN
Animals ON LegacyUnits.PolygonFeature.STIntersects(Animals.Location) = 1

-- Here is an UPDATE query example:
UPDATE    Animals
SET              Unit = LegacyUnits.LegacyUnitID
FROM         LegacyUnits INNER JOIN
                      Animals ON LegacyUnits.PolygonFeature.STIntersects(Animals.Location) = 1