Select @dYS = Sum(IsNull(b.FAmount,0)) -- 期初应收 'fp'销售发票
from
icsale a, t_RP_Contact b
where FCustID = @fItemID
And (Convert(Varchar(8), a.FDate, 112) < @BeginDate )
and a.FBillNo = b.FNumber
and
(
(fNumber like 'fp' + '%')
Or
(fNumber like 'zsefp' + '%')
Or
(fNumber like 'xs' + '%') --此处如果改成 like 'xs%' 两者查询的结果不一样
)
and not (fNumber like 'xskd' + '%')
and b.fStatus <> 16