CREATE function fun_sal_operation_emplist(@perno as nvarchar(2))
returns @empList table(empno nvarchar(20))
as
begin
declare @sn_no nvarchar(10)
declare @from_date datetime
declare @end_date datetime
set @sn_no = @perno
select top 1 @from_date=from_date, @end_date= end_date from Sal_period where sn_no = @sn_no
insert into @empList select distinct empno from hrempm
where ( (duty_flag = 'Y' or Q_date >@end_date) and arr_date<@from_date)
or (arr_date >=@from_date and arr_date <=@end_date)
or (q_date >=@from_date and q_date <=@end_date)
return
end