asked on
@pi_enterprise_id CHAR(5),
@pi_practice_id CHAR(4),
@txt_pregnum INT,
@problem VARCHAR (150),
@pi_cur_person_id UNIQUEIDENTIFIER,
@datefield VARCHAR(10) OUTPUT
)
AS
select @datefield = (CASE WHEN (datefield is null or datefield = '') then '2'
ELSE '1'
END)
from ob_problem_list_
where person_id = @pi_cur_person_id
and pregnum = @txt_pregnum
and problem = @problem
and cpsp_problem_indicator = 'Y'