Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO Messages (Content, SentOn, ChatId, UserId)
- SELECT CONCAT(u.Age, '-', u.Gender, '-', l.Latitude, '-', l.Longitude),
- GETDATE(),
- CASE
- WHEN u.Gender = 'M' THEN ROUND(POWER((CAST(u.Age AS float) / 18), 3), 0)
- ELSE ROUND(SQRT(CAST(u.Age * 2 AS float)), 0)
- END,
- u.Id
- FROM Users AS u
- INNER JOIN Locations AS l
- ON l.Id = u.LocationId
- WHERE u.Id BETWEEN 10 AND 20
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement