Homepage Library Lernen Code-Beispiele Downloads Support Community Foren
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
Microsoft Developer Network >
> 
> 
Process to Streamline Queries

Frage Process to Streamline Queries

  • Freitag, 3. August 2012 16:33
     
     
    Anmelden
    0

    Hi all-

    I run a number of queries against an Oracle db that are desinged to evaluate invoice pricing based on stipulated business pricing rules.

    The pricing logic contains many layers which must be traversed in order to arrive at correct pricing for a given invoice.  This translates into dozens of nested case statements and huge, hard to maintain queries. 

    I would like to move the raw data into Sql Server (I have zero dev. rights in Oracle) and build a more streamlined, efficient process (without so many case statements) but am not sure what my options are.

    Any ideas? 

    I am sparing you an example of the sql used in these quereis but if it helps formulating an answer, I can provide one.

    Thank you!!

     

    Bonediggler

     

Alle Antworten

  • Freitag, 3. August 2012 16:36
     
     
    Anmelden
    0
    You should consider using SSAS.

    Service Delivery & Support Management

     
© 2013 Microsoft. Alle Rechte vorbehalten.
|
Feedback zur Website