Msg 102, Level 15, State 1, Procedure GetByYearDisciplineCourseCatWithDepartment, Line 12 Incorrect syntax near '@DisciplineID'.
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE GetByYearDisciplineCourseCatWithDepartment @Year varchar(128), @DisciplineID int AS BEGIN SELECT CC.CourseCatName, CC.CourseCatID FROM DisciplineCourseCat DCC INNER JOIN CourseCategory CC ON DCC.CourseCatID = DCC.CourseCatID WHERE DCC.[Year] = @Year And DCC.[DisciplineID] = @DisciplineID GO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)