语句中where 1<>1代表什么意思?
as
begin tran
select B.SSZT, B.KMDM, B.TYPEID, B.QCYE KMQCYE, B.QCYE TYPEQCYE
into #TEMPPHJY
from Z_TABZXHSOBJECTQC B
where 1<>1
if (@KMDM<>'') and (@TYPEID>0)
begin
insert into #TEMPPHJY
select B.SSZT, B.KMDM, AA.TYPEID, B.QCYE KMQCYE, 0
from Z_TABKMJE B,
(
select distinct A.SSZT, C.KMDM, A.TYPEID
from Z_TABZXHSKM A,Z_TABKM C
where A.SSZT=@SSZT and
A.SSZT=C.SSZT and
C.KMDM like rtrim(A.KMDM)+'%' and
(C.SFJFZDC=1 or C.SFDFZDC=1) and
C.KMDM like @KMDM+'%' and
A.TYPEID=@TYPEID and
not exists(
select * from Z_TABZXHSOBJECTQC D
where A.SSZT=D.SSZT and
C.KMDM=D.KMDM and
A.TYPEID=D.TYPEID
)
) AA
WHERE AA.SSZT=B.SSZT and
AA.KMDM=B.KMDM and
B.SSZT=@SSZT and
B.QCYE<>0
insert into #TEMPPHJY
select B.SSZT, B.KMDM, AA.TYPEID, B.QCYE KMQCYE, AA.QCYE TYPEQCYE
from Z_TABKMJE B,
(
select A.SSZT, A.KMDM, A.TYPEID, sum(A.QCYE) QCYE
from Z_TABZXHSObjectQC A
where A.SSZT=@SSZT and
A.KMDM=@KMDM and
A.TYPEID=@TYPEID
group by A.SSZT, A.KMDM, A.TYPEID
) AA
WHERE AA.SSZT=B.SSZT and
AA.KMDM=B.KMDM
and AA.QCYE<>B.QCYE
end
else if (@KMDM<>'') and (@TYPEID=0)
begin
insert into #TEMPPHJY
select B.SSZT, B.KMDM, AA.TYPEID, B.QCYE KMQCYE, 0
from Z_TABKMJE B,
(
select distinct A.SSZT, C.KMDM, A.TYPEID
from Z_TABZXHSKM A,Z_TABKM C
where A.SSZT=@SSZT and
A.SSZT=C.SSZT and
C.KMDM like rtrim(A.KMDM)+'%' and
(C.SFJFZDC=1 or C.SFDFZDC=1) and
C.KMDM like @KMDM+'%' and
not exists(
select * from Z_TABZXHSOBJECTQC D
where A.SSZT=D.SSZT and
C.KMDM=D.KMDM and
A.TYPEID=D.TYPEID
)
) AA
WHERE AA.SSZT=B.SSZT and
AA.KMDM=B.KMDM and
B.SSZT=@SSZT and
B.QCYE<>0
insert into #TEMPPHJY
select B.SSZT, B.KMDM, AA.TYPEID, B.QCYE KMQCYE, AA.QCYE TYPEQCYE
from Z_TABKMJE B,
(
select A.SSZT, A.KMDM, A.TYPEID, sum(A.QCYE) QCYE
from Z_TABZXHSObjectQC A
where A.SSZT=@SSZT and
A.KMDM=@KMDM
group by A.SSZT, A.KMDM, A.TYPEID
) AA
WHERE AA.SSZT=B.SSZT and
AA.KMDM=B.KMDM
and AA.QCYE<>B.QCYE
end
else if (@KMDM='') and (@TYPEID=0)
begin
insert into #TEMPPHJY
select B.SSZT, B.KMDM, AA.TYPEID, B.QCYE KMQCYE, 0
from Z_TABKMJE B,
(
select distinct A.SSZT, C.KMDM, A.TYPEID
from Z_TABZXHSKM A,Z_TABKM C
where A.SSZT=@SSZT and
A.SSZT=C.SSZT and
C.KMDM like rtrim(A.KMDM)+'%' and
(C.SFJFZDC=1 or C.SFDFZDC=1) and
not exists(
select * from Z_TABZXHSOBJECTQC D
where A.SSZT=D.SSZT and
C.KMDM=D.KMDM and
A.TYPEID=D.TYPEID
)
) AA
WHERE AA.SSZT=B.SSZT and
AA.KMDM=B.KMDM and
B.SSZT=@SSZT and
B.QCYE<>0
insert into #TEMPPHJY
select B.SSZT, B.KMDM, AA.TYPEID, B.QCYE KMQCYE, AA.QCYE TYPEQCYE
from Z_TABKMJE B,
(
select A.SSZT, A.KMDM, A.TYPEID, sum(A.QCYE) QCYE
from Z_TABZXHSObjectQC A
where A.SSZT=@SSZT
group by A.SSZT, A.KMDM, A.TYPEID
) AA
WHERE AA.SSZT=B.SSZT and
AA.KMDM=B.KMDM
and AA.QCYE<>B.QCYE
end
/*
else
begin
select B.SSZT, B.KMDM, B.TYPEID, B.QCYE KMQCYE, B.QCYE TYPEQCYE
from Z_TABZXHSObjectQC B
WHERE 1<>1
end
*/
select * from #TEMPPHJY order by KMDM, TYPEID
commit tran
return 0
GO