11,850
社区成员




declare @FromTable varchar(50)='tb',@CaiLiaoBianHao as varchar(30) ='abcde',
@strCalLiaoBianHao as varchar(800),@strCRTCaiLiaoBianHao as varchar(800)='',
@strCRTGongChangBianHao as varchar(800)=''
--组合条件(盘点)
declare @ChaXunZuHe varchar(4000);
--组合条件出,入,调库
declare @ChuRuTiaoZuHe varchar(4000);
--下边的赋值方法
set @ChaXunZuHe=(' select shijishuliang,CangKuBianHao,CangKu,BianHao,MingChen,GuiGe,SuoShuGongChang from ( '
+@FromTable+' )A'+' where 1=1 ')
print '1.'+@ChaXunZuHe;
--组合出,入,调库中的查询
set @ChuRuTiaoZuHe= (' select * from View_ImEx where 1=1 ')
print '2.'+@ChuRuTiaoZuHe
if len(rtrim(@CaiLiaoBianHao))<>0
begin
--材料编号不为空 盘点组合条件
set @strCalLiaoBianHao=(' and BianHao='+''+''''+@CaiLiaoBianHao+'''');
print '3.'+@strCalLiaoBianHao
--材料编号不为空 出入调库组合条件
set @strCRTCaiLiaoBianHao=(' and CaiLiaoBianHao='+''+''''+@CaiLiaoBianHao+'''');
print '4.'+@strCRTCaiLiaoBianHao
set @ChaXunZuHe=(@ChaXunZuHe+@strCalLiaoBianHao);
print '5.'+@ChaXunZuHe
set @ChuRuTiaoZuHe=(@ChuRuTiaoZuHe+@strCRTGongChangBianHao);
print '6.'+@ChuRuTiaoZuHe
end
/*
1. select shijishuliang,CangKuBianHao,CangKu,BianHao,MingChen,GuiGe,SuoShuGongChang from ( tb )A where 1=1
2. select * from View_ImEx where 1=1
3. and BianHao='abcde'
4. and CaiLiaoBianHao='abcde'
5. select shijishuliang,CangKuBianHao,CangKu,BianHao,MingChen,GuiGe,SuoShuGongChang from ( tb )A where 1=1 and BianHao='abcde'
6. select * from View_ImEx where 1=1
*/