Database Connector Error

I have created a stored procedure for my report.. create Procedure [dbo].[sp_Score_Grade] @Month int, @Year int, @Log_User varchar(30) AS ( SELECT Log_User, Count = COUNT(Det

Solution 1:

Your parameter names are delimited in the query, so SQL Server is treating them as literal strings. Try

Log_User like @Log_User
   AND Month(Sched_Start) = @Month
   AND Year(Sched_Start) = @Year