Advertisement
Guest User

Untitled

a guest
Oct 13th, 2019
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.27 KB | None | 0 0
  1. CREATE FUNCTION udf_UserTotalCommits(@username VARCHAR(30))
  2. RETURNS INT AS
  3. BEGIN
  4.     DECLARE @commits INT =
  5.     (
  6.         SELECT
  7.             COUNT(*)
  8.         FROM Commits c
  9.         JOIN Users u ON c.ContributorId = u.Id
  10.         GROUP BY u.Username
  11.         HAVING u.Username = @username
  12.     );
  13.     RETURN @commits
  14. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement