Întrebari și răspunsuri

IF @pt_co = 0
SELECT @ret_val = (s.integral*(b.ore_reg+b.ore_aco+b.ore_ate+b.ore_rep)*8)/(@ore_lun*b.ore_norm),
@ret_ore = b.ore_reg+b.ore_aco+b.ore_ate+b.ore_rep
FROM blc_linii s
INNER JOIN blc b ON s.pl_blc=b.pct_lcr AND s.id_blc=b.id
WHERE s.anluna=@anluna AND s.pct_lcr=@pl_sp AND s.id=@id_sp
ELSE
SELECT @ret_val = 0,
@ret_ore = 0,
@ret_proc = 0