SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
--update sm_system_info set sys_cwend=25
ALTER<wbr><wbr><wbr><wbr> Procedure sp_BsGetCwDate_RS(@beginDate varchar(20) out,@endDate varchar(20) out)<br> as<br> declare @sys_cwend int<br> declare @CurrMonthLastDay int<br> declare @PreMonthLastDay int<br> --declare @PreDate varchar(20)<br> declare @CurrFirstDate varchar(20)<br> declare @CurrLastDate varchar(20)<br> --declare @NextDate varchar(20)<br> declare @CurrDate varchar(20)<br> declare @CurrDay int</wbr></wbr></wbr></wbr>
declare @tempBegin varchar(20)
declare @tempEnd varchar(20)
Begin
select @sys_cwend = sys_cwend from sm_system_info
set @CurrDate = convert(varchar, @beginDate,120)
print print '@CurrDay <= @sys_cwend'
set @PreMonthLastDay<wbr> = day(convert(datetime,@CurrFirstDate)-1)<br> print <a href="mailto:'@PreMonthLastDay='+convert(varchar,@PreMonthLastDay">'@PreMonthLastDay='+convert(varchar,@PreMonthLastDay</a>)<br> set @CurrMonthLastDay = day(dateadd(day,-1,dateadd(month,1,convert(datetime,@CurrFirstDate))))<br> print <a href="mailto:'@CurrMonthLastDay='+convert(varchar,@CurrMonthLastDay">'@CurrMonthLastDay='+convert(varchar,@CurrMonthLastDay</a>)<br> print convert(varchar,@sys_cwend+1)<br> if (@PreMonthLastDay < @sys_cwend+1)<br> begin<br> print <a href="mailto:'@PreMonthLastDay">'@PreMonthLastDay</a> < @sys_cwend+1'<br> set @tempBegin = @CurrFirstDate<br> print convert(varchar,@tempBegin)<br> end<br> else<br> begin<br> print <a href="mailto:'@PreMonthLastDay">'@PreMonthLastDay</a> >= @sys_cwend+1'<br> set @tempBegin = left(convert(varchar,convert(datetime,@CurrFirstDate)-1,120),4) + '-' +<br> convert(varchar,month(convert(datetime,@CurrFirstDate)-1)) + '-' +<br> convert(varchar,@sys_cwend+1)<br> print @tempBegin<br> end<br> if (@CurrMonthLastDay < @sys_cwend)<br> begin<br> print <a href="mailto:'@CurrMonthLastDay">'@CurrMonthLastDay</a> < @sys_cwend'<br> set @tempEnd = convert(varchar, dateadd(day,-1,dateadd(month,1,convert(datetime,@CurrFirstDate))),120)<br> print @tempEnd<br> end<br> else<br> begin<br> print <a href="mailto:'@CurrMonthLastDay">'@CurrMonthLastDay</a> >= @sys_cwend'<br> set @tempEnd = convert(varchar, dateadd(day,-1,dateadd(month,1,convert(datetime,@tempBegin))),120)<br> print @tempEnd<br> end<br> end<br> else<br> begin<br> --------------------------------------------------------------------------------------------------------------<br> print <a href="mailto:'@CurrDay">'@CurrDay</a> > @sys_cwend'<br> set @PreMonthLastDay<wbr> = day(convert(datetime,@CurrLastDate))<br> print <a href="mailto:'@PreMonthLastDay='+convert(varchar,@PreMonthLastDay">'@PreMonthLastDay='+convert(varchar,@PreMonthLastDay</a>)<br> set @CurrMonthLastDay = day(dateadd(day,-1,dateadd(month,2,convert(datetime,@CurrFirstDate))))<br> print <a href="mailto:'@CurrMonthLastDay='+convert(varchar,@CurrMonthLastDay">'@CurrMonthLastDay='+convert(varchar,@CurrMonthLastDay</a>)<br> if (@PreMonthLastDay <= @sys_cwend+1)<br> begin<br> print <a href="mailto:'@PreMonthLastDay">'@PreMonthLastDay</a> <= @sys_cwend+1'<br> set @tempBegin = @CurrLastDate<br> print convert(varchar,@tempBegin)<br> end<br> else<br> begin<br> print <a href="mailto:'@PreMonthLastDay">'@PreMonthLastDay</a> > @sys_cwend+1'<br> set @tempBegin = left(convert(varchar,convert(datetime,@CurrFirstDate),120),4) + '-' +<br> convert(varchar,month(convert(datetime,@CurrFirstDate))) + '-' +<br> convert(varchar,@sys_cwend+1)<br> print @tempBegin<br> end<br> if (@CurrMonthLastDay < @sys_cwend)<br> begin<br> print <a href="mailto:'@CurrMonthLastDay">'@CurrMonthLastDay</a> < @sys_cwend'<br> set @tempEnd = convert(varchar, dateadd(day,-1,dateadd(month,2,convert(datetime,@CurrFirstDate))),120)<br> print @tempEnd<br> end<br> else<br> begin<br> print <a href="mailto:'@CurrMonthLastDay">'@CurrMonthLastDay</a> >= @sys_cwend'<br> set @tempEnd = convert(varchar, dateadd(day,-1,dateadd(month,1,convert(datetime,@tempBegin))),120)<br> print @tempEnd<br> end<br> --------------------------------------------------------------------------------------------------------------<br> end<br> set @begindate = @tempBegin<br> set @enddate<wbr><wbr> = @tempEnd<br> End</wbr></wbr></wbr></wbr>
<wbr></wbr>
<wbr></wbr>
<wbr></wbr>
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
<wbr></wbr>