alter procedure "DBA".bpf_CheckDateInterval(in @SD datetime,in @ED datetime,in @Interval integer)
on exception resume
begin
  declare @res integer;declare @CurInt integer;declare @ErrorMsg varchar( 500 );
  select  1  into @res;
  select datediff(dd,@SD,@ED)+ 1  into @CurInt;
  select 'Îøèáêà. Îò÷åò íå áóäåò ñôîðìèðîâàí. Ïðåâûøåí èíòåðâàë â '||convert(varchar( 2 ),@Interval)||' äíåé.' into @ErrorMsg;
  if @CurInt>@Interval then
    select  0  into @res;
    raiserror  17999  @ErrorMsg
  end if
  ;
  return(@res)
end

select dba.bpf_CheckDateInterval ( '2008-01-01', '2008-01-21',  10  )