declare @sql1 varchar(8000)
declare @FBrnoName varchar(100)
declare @FdateFrom datetime
declare @FdateEnd datetime
declare @FAccountNumberFrom nvarchar(100)
declare @FAccountNumberEnd nvarchar(100)
set @FBrnoName='实业有限公司'
set @FdateFrom='2007-01-01'
set @FdateEnd='2007-01-31'
set @FAccountNumberFrom='5101.001.001'
set @FAccountNumberEnd='5101.005.002'set @sql1 = 'Update '+@FBrnoName+'..t_Voucher set FImportID=0 WHERE FVoucherID IN(select DISTINCT v.FVoucherID
from '+@FBrnoName+'..t_Voucher v INNER JOIN '+@FBrnoName+'..t_VoucherEntry a ON v.FVoucherID=a.FVoucherID
left outer join '+@FBrnoName+'.. t_Account b on a.FAccountID=b.FAccountID where v.Fdate >= '''+convert(char(10),@FdateFrom,121)+'''
And v.Fdate <='+convert(char(10),@FdateEnd,121)+'and b.Fnumber >= '''+@FAccountNumberFrom+'''
And b.Fnumber <='''+@FAccountNumberEnd+''')'
EXEC(@sql1)
declare @FBrnoName varchar(100)
declare @FdateFrom datetime
declare @FdateEnd datetime
declare @FAccountNumberFrom nvarchar(100)
declare @FAccountNumberEnd nvarchar(100)
set @FBrnoName='实业有限公司'
set @FdateFrom='2007-01-01'
set @FdateEnd='2007-01-31'
set @FAccountNumberFrom='5101.001.001'
set @FAccountNumberEnd='5101.005.002'set @sql1 = 'Update '+@FBrnoName+'..t_Voucher set FImportID=0 WHERE FVoucherID IN(select DISTINCT v.FVoucherID
from '+@FBrnoName+'..t_Voucher v INNER JOIN '+@FBrnoName+'..t_VoucherEntry a ON v.FVoucherID=a.FVoucherID
left outer join '+@FBrnoName+'.. t_Account b on a.FAccountID=b.FAccountID where v.Fdate >= '''+convert(char(10),@FdateFrom,121)+'''
And v.Fdate <='+convert(char(10),@FdateEnd,121)+'and b.Fnumber >= '''+@FAccountNumberFrom+'''
And b.Fnumber <='''+@FAccountNumberEnd+''')'
EXEC(@sql1)
declare @FBrnoName nvarchar(100)
declare @FdateFrom datetime
declare @FdateEnd datetime
declare @FAccountNumberFrom nvarchar(100)
declare @FAccountNumberEnd nvarchar(100)
set @FBrnoName=N'实业有限公司'
set @FdateFrom='2007-01-01'
set @FdateEnd='2007-01-31'
set @FAccountNumberFrom='5101.001.001'
set @FAccountNumberEnd='5101.005.002'set @sql1 = 'Update '+@FBrnoName+'..t_Voucher set FImportID=0 WHERE FVoucherID IN(select DISTINCT v.FVoucherID
from '+@FBrnoName+'..t_Voucher v INNER JOIN '+@FBrnoName+'..t_VoucherEntry a ON v.FVoucherID=a.FVoucherID
left outer join '+@FBrnoName+'.. t_Account b on a.FAccountID=b.FAccountID where v.Fdate >= '''+convert(char(10),@FdateFrom,121)+'''
And v.Fdate <='''+convert(char(10),@FdateEnd,121)+''' and b.Fnumber >= '''+@FAccountNumberFrom+'''
And b.Fnumber <='''+@FAccountNumberEnd+''')'
print @sql1
EXEC(@sql1)
declare @FBrnoName varchar(100)
declare @FdateFrom datetime
declare @FdateEnd datetime
declare @FAccountNumberFrom nvarchar(100)
declare @FAccountNumberEnd nvarchar(100)
set @FBrnoName='实业有限公司'
set @FdateFrom='2007-01-01'
set @FdateEnd='2007-01-31'
set @FAccountNumberFrom='5101.001.001'
set @FAccountNumberEnd='5101.005.002'set @sql1 = 'Update v set FImportID=0 WHERE FVoucherID IN(select DISTINCT v.FVoucherID
from '+@FBrnoName+'..t_Voucher v INNER JOIN '+@FBrnoName+'..t_VoucherEntry a ON v.FVoucherID=a.FVoucherID
left outer join '+@FBrnoName+'.. t_Account b on a.FAccountID=b.FAccountID where v.Fdate >= '''+convert(char(10),@FdateFrom,121)+'''
And v.Fdate <='''+convert(char(10),@FdateEnd,121)+''' and b.Fnumber >= '''+@FAccountNumberFrom+'''
And b.Fnumber <='''+@FAccountNumberEnd+''')'
EXEC(@sql1)