Hi Guys,
I need help to execute SQL query in QTP , here is the scenario that I
have several SQL queries in some of them trying to get data from view
but these queries not runing in QTP, Other queries which dont have
view are runing fine please help me ASAP .
SQL query with view
SELECT DISTINCT
max(ir.RoundDate),
p.Name ,
bd.BusinessDesc
FROM
PortfolioCompanyFinancials pf,
PortfolioCompanyView p,
Disbursement d,
PortfolioCompanyBusinessDesc bd,
InvestmentRound ir,
FirmView firm, (View)
Fund fund
WHERE
p.PortfolioCompanyID = pf.PortfolioCompanyID
and d.RoundId=ir.RoundID
and bd.PortfolioCompanyID=p.PortfolioCompanyID
and ir.PortfolioCompanyID=p.PortfolioCompanyID
and firm.FirmID = fund.FirmID
and fund.FundID = d.PEInvestorID
and pf.CurrentRatio between 1 and 2
and pf.IsLatest = 'Y'
and firm.NationCode = 'US'
and fund.FundraisingStatusCode in ('F' , 'Z')
GROUP BY p.Name, bd.BusinessDesc
ORDER BY p.Name
SQl query with out view working fine
USE PrivateEquity
GO
SELECT DISTINCT
max(ir.RoundDate) as LastInvestmentReceived,
p.Name as CompanyName,
bd.BusinessDesc as BusinessDescription
FROM
PortfolioCompanyView p,
PortfolioCompanyFinancialsCurrencyFields pf,
PortfolioCompanyBusinessDesc bd,
InvestmentRound ir
WHERE
pf.PortfolioCompanyID = p.PortfolioCompanyID
and ir.PortfolioCompanyID=p.PortfolioCompanyID
and bd.PortfolioCompanyID=p.PortfolioCompanyID
and pf.CurrencyCode = 'USD'
and pf.NetSales between 20000000 and 100000000
and pf.ProfitMargin between 1 and 10
and pf.IsLatest = 'Y'
GROUP BY p.Name, bd.BusinessDesc
I would really appreicate
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
-~----------~----~----~----~------~----~------~--~---
