INSERT Messages
(Content, SentOn, ChatId, UserId)
SELECT
    CONCAT(us.Age, '-', us.Gender, '-', l.Latitude, '-', l.Longitude),
    CONVERT(DATE, GETDATE()),
    [ChatId] = CASE
    WHEN us.Gender = 'F' THEN ROUND(SQRT((us.Age * 2)),0)
    WHEN us.Gender = 'M' THEN ROUND(POWER((us.Age / 18), 3),0)
    END,
    us.Id
FROM Users AS us
INNER JOIN Locations AS l
ON l.Id = us.LocationId
WHERE us.Id >= 10 AND us.Id <= 20