- 1
if @Year=2010 if @isInvalid=1 if @IsBefore67=1 select'14'SCH,'-'NCH,'-'DOP,'-'FFOMS,'-'TFOMS,'-'FSS else select'8'SCH,'6'NCH,'-'DOP,'-'FFOMS,'-'TFOMS,'-'FSS else if @IsBefore67=1 select'20'SCH,'-'NCH,'-'DOP,'1.1'FFOMS,'2'TFOMS,'2.9'FSS else select'14'SCH,'6'NCH,'-'DOP,'1.1'FFOMS,'2'TFOMS,'2.9'FSS else if @Year=2011 if @isInvalid=1 if @IsBefore67=1 select'16'SCH,'-'NCH,'-'DOP,'1.1'FFOMS,'1.2'TFOMS,'1.9'FSS else select'10'SCH,'6'NCH,'-'DOP,'1.1'FFOMS,'1.2'TFOMS,'1.9'FSS else if @IsBefore67=1 select'26'SCH,'-'NCH,'-'DOP,'3.1'FFOMS,'2'TFOMS,'2.9'FSS else select'20'SCH,'6'NCH,'-'DOP,'3.1'FFOMS,'2'TFOMS,'2.9'FSS else if @Year=2012 if @isInvalid=1 if @IsBefore67=1 select'16'SCH,'-'NCH,'-'DOP,'2.3'FFOMS,'-'TFOMS,'1.9'FSS else select'10'SCH,'6'NCH,'-'DOP,'2.3'FFOMS,'-'TFOMS,'1.9'FSS else if @IsBefore67=1 select'22'SCH,'-'NCH,'-'DOP,'5.1'FFOMS,'-'TFOMS,'2.9'FSS else select'16'SCH,'6'NCH,'-'DOP,'5.1'FFOMS,'-'TFOMS,'2.9'FSS else if @Year>=2013 if @isInvalid=1 if @IsBefore67=1 select'16'SCH,'-'NCH,'-'DOP,'2.3'FFOMS,'-'TFOMS,'1.9'FSS else select'10'SCH,'6'NCH,'-'DOP,'2.3'FFOMS,'-'TFOMS,'1.9'FSS else if @IsBefore67=1 select'22'SCH,'-'NCH,'-'DOP,'5.1'FFOMS,'-'TFOMS,'2.9'FSS else select'16'SCH,'6'NCH,'-'DOP,'5.1'FFOMS,'-'TFOMS,'2.9'FSS
Код ХП, определяющей некоторые параметры в зависимости от переданных значений