Hi,
I have a number of SQL statement's and as I'm new to Business Objects, what is the best way for them to be modelled using designer.
Example 1.
Select abc
FROM
abc
SummaryRatesAndPricesRec a
WHERE ALI_HAS_LEND = AssetLiabilityItem_TIL
AND a.SummaryRatesAndPrices_TIL = (SELECT MAX(b.SummaryRatesAndPrices_TIL) FROM SummaryRatesAndPricesRec b WHERE b.SRP_HAS_RPC = a.SRP_HAS_RPC)
Example 2.
Select abc
FROM abc
WHERE
SummaryRatesAndPricesRec b WHERE b.SRP_HAS_RPC = SRP_HAS_RPC)
AND TDBCode = RPCODECode
UNION
SELECT
HDEALDealNumber AS "Deal Number",
etc..
Many Thanks for your help
Craig
I have a number of SQL statement's and as I'm new to Business Objects, what is the best way for them to be modelled using designer.
Example 1.
Select abc
FROM
abc
SummaryRatesAndPricesRec a
WHERE ALI_HAS_LEND = AssetLiabilityItem_TIL
AND a.SummaryRatesAndPrices_TIL = (SELECT MAX(b.SummaryRatesAndPrices_TIL) FROM SummaryRatesAndPricesRec b WHERE b.SRP_HAS_RPC = a.SRP_HAS_RPC)
Example 2.
Select abc
FROM abc
WHERE
SummaryRatesAndPricesRec b WHERE b.SRP_HAS_RPC = SRP_HAS_RPC)
AND TDBCode = RPCODECode
UNION
SELECT
HDEALDealNumber AS "Deal Number",
etc..
Many Thanks for your help
Craig