Viewing 2 posts - 1 through 2 (of 2 total)
Duh! I screwed up the "Active" part of the WHERE clause - it should be ((@active = 0) OR (Active = @active)) - that is the problem....
November 30, 2010 at 1:11 pm
#1257003
CREATE PROCEDURE [dbo].[GetNonEmployeeByEmpID]
-- Add the parameters for the stored procedure here
@empID int,
@active int
AS
BEGIN
-- SET NOCOUNT ON added to prevent...
November 30, 2010 at 1:05 pm
#1256998