liviu.costea:

Cand folosesc sql dinamic ajung sa am instructiuni IF si ELSE in codul procedurii.

Diana:

CASE

WHEN @EmployeeId IS NULL THEN ''

ELSE 'AND EmployeeId = @EmployeeId '

END