触发器多个判断

[u010535898]

表 prdt
prd_no up_p up_s
620032 1.2 2.5
620045 3.6 4.2
651043 0.8 1.6
............................................
表 hj
hj_ps prd_no up


向表hj插入数据当hi_ps=p，hj.prd_no=prdt.prdt时 up大于对应的up_p 则rollback
向表hj插入数据当hi_ps=s，hj.prd_no=prdt.prdt时 up大于对应的up_s 则 rollback
请问这样的两个判断怎么写触发器

[xiaodongni]

--把prdt进行一个列转行就好判断。或者直接判断2次。分别对hj_ps=s or=p进行判断。必须都不存在才不提交

if  exists (select * from (select * from prdt unpivot 
( up for hj_ps in([up_p],[up_s])) as t) as a 
join inserted as b
on a.prd_no=b.prd_no and RIGHT(hj_ps,1)=b.hj_ps
and a.up<b.up)
rollback