Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can I Use Conditions Within A View?
Message
 
 
À
17/06/2009 17:14:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01406759
Message ID:
01406768
Vues:
28
Can you use CROSS APPLY within a view?

>I am using the following code in a VFP view to return customer information from a SQL server. This view includes references to SQL server stored procedures named getcustomerbalance and getcustomeramountdue. I'm trying to speed up this view and was wondering if I could make the call to getcustomeramountdue only if getcustomerbalance returns a value greater than zero. If so whats the best way to implement it?
>
>
>SELECT Customer.customerid, ;
> Customer.cCUSTNO, ;
> Customer.dENTERED, ;
> Customer.nCOBALANCE, ;
> Customer.dBILL, ;
> Customer.dLASTPMT, ;
> Customer.cREP, ;
> Customer.cLASTNAME, ;
> Customer.cFIRSTNAME, ;
> Customer.cTITLE, ;
> Customer.cADDRESS, ;
> Customer.cCITY, ;
> Customer.cSTATE, ;
> Customer.cZIP, ;
> Customer.cPHONE, ;
> Customer.cPHONE2, ;
> Customer.cPHONE3, ;
> Customer.cCONTACT, ;
> Customer.mNOTES, ;
> Customer.cTAXNO, ;
> Customer.cIDNO, ;
> Customer.cIDDESC, ;
> Customer.dNEXTPMT, ;
> Customer.nTAX, ;
> Customer.lCharge_Off, ;
> Customer.cfinanceno, ;
> CAST((RTRIM(Customer.clastname)+', '+Customer.cfirstname) AS CHAR(68)) AS cfullname, ;
> CAST((RTRIM(Customer.cfirstname)+' '+Customer.clastname) AS CHAR(68)) AS cprtname, ;
> Dbo.getcustomerbalance(Customer.cfinanceno) AS qybalance, ;
> Dbo.getcustomeramountdue(Customer.cfinanceno) AS qyamountdue, ;
> Dbo.GetPmtsInvoiced(Customer.cfinanceno) AS nPmtsInvoiced;
> FROM dbo.Customer Customer ;
> ORDER BY 26
>
>Thanks In Advance
>
>Jeff
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform