set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[stpGetStats]
	@Username	varchar(50),
	@Channel	varchar(50)
AS
BEGIN

	SET NOCOUNT ON;

    SELECT	COUNT(LineText) AS 'lines_said'
	FROM	UserTalk INNER JOIN
			ircUsers ON UserTalk.UserID = ircUsers.UserID
	WHERE	ircUsers.UserName = @username AND
			UserTalk.Channel = @Channel

END