|
Discusión Técnica
|
Autor |
Tópico:
Problema con query ayuda |
|
obelich
|
Problema con query ayuda
Publicado:
Friday, June 11, 2010 9:29 AM (PST)
|
|
|
Hola que tal muy buen dia aqui ando molestando tengo un problema con un query que ocupo hacer con el SQL Server este ya lo realize con PostreSQL y me funciona correctamente pero en SQL Server no me funciona si me pudieran ayudar a hacerlo funcionar con SQL Server se los agradeceria mucho
El problema que tengo es con lo del campo de factura numero resulta que cuando ejecuto el query me tira un null en vez de darme el numero de factura de antemano gracias ^_^
SELECT
"Ped".patente,
"Ped".pedimento,
"Ped".aduana,
"Ped".tipo,
"Ped".clave,
"CTE".rfc,
"CTE".nombre,
"Ped".fechadepago,
"Ped".fechadepagobanco,
"Ped".tipodecambio,
"Par".fraccion,
"Par".numero as "Partida Numero",
"Par".descripcion,
"Par".paisdeorigen,
"Par".paisvendcomp,
"Par".valorenaduana,
"Par".valorcomercial,
"Par".valorcomercialdlls,
"Par".cantidadcomercial,
"Par".unidadcomercial,
"Par".cantidadtarifa,
"Par".unidadtarifa,
--"Fact"."numero",
--(SELECT "Fact"."numero" from "vt_pedimentofacturas" "Fact" where "Fact"."id" = "Ped"."id") as "Factura numero",
(SELECT top(1) "Pcnt"."tipodetasa" from "vt_partidacontrib" "Pcnt" where "Pcnt"."partida"="Par"."id") as "Tipo de Tasa",
(SELECT top(1) "Pcnt"."tasa" from "vt_partidacontrib" "Pcnt" where "Pcnt"."partida"="Par"."id") as "Tipo de Tasa",
(SELECT top(1) "Cs"."caso" FROM "vt_casos" "Cs" where "Cs"."partida" = "Par"."id") as "Casos",
--Pcnt.tasa,
--Pcnt.tipodetasa,
--(SELECT SUM("Pcnt"."Tasa") FROM "vt_partidacontrib" "Pcnt" WHERE ("Pcnt"."partida" = "Par"."id" and "Pcnt"."Contribucion" = 6 and "Pcnt".Reflejar = 1)),
( SELECT SUM( "Pcnt"."monto" ) FROM "vt_partidacontrib" "Pcnt" WHERE "Pcnt"."contribucion" = 3 AND "Pcnt"."partida" = "Par"."id" AND "Pcnt"."fp" = 0 ) AS "IVA FP_0",
( SELECT SUM( "Pcnt"."monto" ) FROM "vt_partidacontrib" "Pcnt" WHERE "Pcnt"."contribucion" = 3 AND "Pcnt"."partida" = "Par"."id" AND "Pcnt"."fp" = 5 ) AS "IVA FP_5",
( SELECT SUM( "Pcnt"."monto" ) FROM "vt_partidacontrib" "Pcnt" WHERE "Pcnt"."contribucion" = 2 AND "Pcnt"."partida" = "Par"."id" AND "Pcnt"."fp" = 2 ) AS "Cuota Conpensatoria",
--Cs.caso,
( SELECT SUM( "Pcnt"."monto" ) FROM "vt_partidacontrib" "Pcnt" WHERE "Pcnt"."contribucion" = 6 AND "Pcnt"."partida" = "Par"."id" AND "Pcnt"."fp" = 0 ) AS "IGI FP_0",
( SELECT SUM( "Pcnt"."monto" ) FROM "vt_partidacontrib" "Pcnt" WHERE "Pcnt"."contribucion" = 6 AND "Pcnt"."partida" = "Par"."id" AND "Pcnt"."fp" = 5 ) AS "IGI FP_5"
FROM "vt_pedimentos" "Ped"
INNER JOIN "vt_clientes" "CTE" ON ( "CTE"."id" = "Ped"."cliente" )
INNER JOIN "vt_partidas" "Par" ON ( "Par"."pedimento" = "Ped"."id" )
--INNER JOIN "vt_pedimentofacturas" "Fact" ON ("Ped"."id" = "Fact"."id")
--INNER JOIN "vt_casos" "Cs" ON ("Par"."id" = "Cs"."partida")
--INNER JOIN "vt_partidacontrib" "Pcnt" ON ("Pcnt"."partida" = "Par"."id")
WHERE (("Ped"."patente" = '3332' or "Ped"."patente" = '3890' or "Ped"."patente" = '3623' or "Ped"."patente" = '3777')
AND "Ped"."fechadepago" BETWEEN '2009-01-07' AND '2009-01-31'
AND ( "CTE"."numero" = '375' or "CTE"."numero" = '1172' or "CTE"."numero" = '200' or "CTE"."numero" = '1107')
AND ( RTRIM( "Ped"."firmapedimento" ) <> '' AND RTRIM( "Ped"."firmabanco" ) <> '' ) ) ORDER BY "Ped"."pedimento", "Par"."numero"
|
|
|
|
 |
|