snowwoman Katarina Macko Novi Sad
Član broj: 20897 Poruke: 17 *.dcccorp.com.
|
Pozdrav svima,
pokusavam da napravim paket za prebacivanje podataka iz SQL server baze u FoxPro bazu. Podaci koji se prebacuju zavise od spoljasnjeg parametra. Kada SELECT upit koji prebacuje podatke (koristim Transform Data Task) napisem sa fiksnim vrednostima radi, a kada stavim da gleda parametar, javlja mi sintax error.
Upit koji radi:
select productID, office_name, office_infoID, officeID, serviceID, currID,
bankID, bank_name, branch_name, branch_infoID, branchID, rtrim(left(c.corr_name,25))+'('+cast(c.priority as varchar)+')' as corr_name, p.corrID as corrID, countryID, cityID, p.status as status, p.folio_type as folio_type
from dbo.v_Product_POS p LEFT OUTER JOIN dba.Correspondent c on p.corrID=c.corrID
where p.status=1
and ((select new_pp from oper.Agent where Acode='M0001')*p.officeID>=0
or (select new_pp from oper.Agent where Acode='M0001')*p.branchID>=0)
order by productID desc
Upit koji ne radi:
select productID, office_name, office_infoID, officeID, serviceID, currID,
bankID, bank_name, branch_name, branch_infoID, branchID, rtrim(left(c.corr_name,25))+'('+cast(c.priority as varchar)+')' as corr_name, p.corrID as corrID, countryID, cityID, p.status as status, p.folio_type as folio_type
from dbo.v_Product_POS p LEFT OUTER JOIN dba.Correspondent c on p.corrID=c.corrID
where p.status=1
and ((select new_pp from oper.Agent where Acode=?)*p.officeID>=0
or (select new_pp from oper.Agent where Acode=?)*p.branchID>=0)
order by productID desc
Imam globalni parametar Acode definisan za paket.
U cemu je problem? Da li ovi upiti za DTS ne podrzavaju ugnjezdene upite?
Unapred zahvalna :)
|