Advertisement
dragonbs

Cash in User Games Odd Rows

Oct 13th, 2023
1,136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.53 KB | None | 0 0
  1. CREATE FUNCTION ufn_CashInUsersGames(@gameName NVARCHAR(50))
  2. RETURNS TABLE
  3. AS
  4. RETURN SELECT(SELECT SUM([Cash]) AS [SumCash]
  5.                 FROM
  6.                     (SELECT ROW_NUMBER() OVER (PARTITION BY [g].[Name] ORDER BY [ug].[Cash] DESC) AS [Row]
  7.                             ,[g].[Name] AS [Game Name]
  8.                             ,[ug].[Cash]
  9.                         FROM [UsersGames] AS [ug]
  10.                         JOIN [Games] AS [g] ON [ug].[GameId] = [g].[Id]
  11.                         WHERE [g].[Name] = @gameName
  12.                      ) AS [Rows]
  13.                 WHERE [Row] % 2 <> 0
  14.               ) AS [SumCash]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement