am rezolvat pana la urma.......am modificat partea cu 'WHEN...TEHN PAUSE' cu
WHEN dbo.N_QASStation.TimeStation<>0 and Cycle.timeInWsSeconds>dbo.N_QASStation.TimeStation
and ((Cycle.startTime>= '''+@dataInP1+''' and Cycle.startTime<= '''+@dataOutP1+''')
or (Cycle.startTime>= '''+@dataInP2+''' and Cycle.startTime<= '''+@dataOutP2+''')
or (Cycle.startTime>= '''+@dataInP3+''' and Cycle.startTime<= '''+@dataOutP3+''')
or (Cycle.startTime>= '''+@dataInP4+''' and Cycle.startTime<= '''+@dataOutP4+''')
) THEN ''PAUSE''
sunt sigur ca exista si o varianta mai simpla dar nu am stiut cum altfel (ma refer la toata partea cu dataINP1,P2 etc...la cum sunt declarate ele etc)