Lucas Morgan
51d234d871
Replace MSAL and custom cookie auth with Microsoft.Identity.EntityFramework Also some UI redesign to accommodate different login experience.
19 lines
459 B
Transact-SQL
19 lines
459 B
Transact-SQL
CREATE FUNCTION [session].[MaxNewSessionsPerUser]() RETURNS INT
|
|
AS
|
|
BEGIN
|
|
|
|
DECLARE @MaxNewSessionsCreatedByAnyOneUser INT;
|
|
|
|
WITH CountOfNewSessionsPerPlayer AS
|
|
(
|
|
SELECT COUNT(*) as TotalNewSessions
|
|
FROM [session].[Session]
|
|
WHERE Player2Id IS NULL
|
|
GROUP BY Player1Id
|
|
)
|
|
SELECT @MaxNewSessionsCreatedByAnyOneUser = MAX(CountOfNewSessionsPerPlayer.TotalNewSessions)
|
|
FROM CountOfNewSessionsPerPlayer
|
|
|
|
RETURN @MaxNewSessionsCreatedByAnyOneUser
|
|
END
|