• This snippet doesn't even make sense:
    AND (NOT EXISTS (SELECT 1 FROM @SampleStatusId) OR samp.SampleCondition IN (SELECT id FROM @SampleStatusId))

    EDIT: Nevermind, it does now.