on 05-12-2010 11:06 PM
Hola a todos, necesito incoporar una búsqueda formateada a una orden de compra y no logro descubrir el error que me impide ejecutarla, adjunto qwery.
SELECT
CASE
WHEN opor.carcode = '96705150P' and opor.U_SBO_TIPOSR=u201905u2019) THEN ($[38.21.1]/300)
ELSE $[38.21.1]
END
Desde ya agradezco su valiosa ayuda
A ver intenta asi
if
select $[opor.carcode ] in ( '96705150P') and select $[opor.U_SBO_TIPOSR] in (u201905u2019)
select $[$38.21.1]/300 --then
select $[$38.21.1] --else
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
11 | |
10 | |
6 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.