Advertisement
Guest User

Untitled

a guest
Aug 6th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.69 KB | None | 0 0
  1. SELECT
  2.      T.CDate AS NewDate,
  3.      T.MaxVal,
  4.      T.CurName
  5. FROM (
  6.     SELECT
  7.         MAX(CR.CurrencyValue) - MIN(CR.CurrencyValue) AS MaxVal,
  8.         CR.CurrencyName AS CurName,
  9.         CAST(YEAR(CR.Date) AS nvarchar) + N'.' + CAST(MONTH(CR.Date) AS nvarchar) AS CDate
  10.     FROM Currencies CR
  11.     GROUP BY YEAR(CR.Date), MONTH(CR.Date), CR.CurrencyName) AS T
  12. WHERE T.MaxVal IN (
  13.     SELECT
  14.         MAX(T1.MaxVal)
  15.     FROM (
  16.         SELECT
  17.             MAX(CR1.CurrencyValue) - MIN(CR1.CurrencyValue) AS MaxVal,
  18.             CR1.CurrencyName AS CurName,
  19.             CAST(YEAR(CR1.Date) AS nvarchar) + N'.' + CAST(MONTH(CR1.Date) AS nvarchar) AS CDate
  20.         FROM Currencies AS CR1
  21.         GROUP BY YEAR(CR1.Date), MONTH(CR1.Date), CR1.CurrencyName) as T1
  22.     GROUP BY T1.CurName)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement