178972_CREATE_PROCEDURE_Ranking
CREATE PROCEDURE Ranking @username varchar(50) AS declare @tname varchar(100); set @tname =’tips_’+@username ; declare @strex nvarchar(2000); set @strex=’select isnull((sum(game1)+sum(game2)+sum(game3)+sum(game4)+sum(game5)+sum(game6)+sum(game7)+sum(game8)+sum(game9))/count(game1),0) from( select case ua.game1 when 0 then 0 …
Read More