Advertisement
simonradev

ASd

Oct 18th, 2017
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.39 KB | None | 0 0
  1. INSERT INTO Messages (Content, SentOn, ChatId, UserId)
  2. SELECT CONCAT(u.Age, '-', u.Gender, '-', l.Latitude, '-', l.Longitude),
  3.        GETDATE(),
  4.        CASE
  5.         WHEN u.Gender = 'M' THEN ROUND(POWER((CAST(u.Age AS float) / 18), 3), 0)
  6.         ELSE ROUND(SQRT(CAST(u.Age * 2 AS float)), 0)
  7.        END,
  8.        u.Id
  9. FROM Users AS u
  10. INNER JOIN Locations AS l
  11. ON l.Id = u.LocationId
  12. WHERE u.Id BETWEEN 10 AND 20
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement