Tuesday 1 April 2014

Display method

display Amount JournalAmount()
{
    Paymentrequest Paymentrequest;
    Paymentrequestline Paymentrequestline;

    select Paymentrequest where Paymentrequest.PaymentjournalID == this.PaymentjournalID;
    select sum(Amount) from Paymentrequestline where Paymentrequestline.JournalNum == Paymentrequest.JournalNum;
    return Paymentrequestline.Amount;

No comments:

Post a Comment

SQL/SSRS Interview questions I thought of blogging some SQL/SSRS interview questions.

Below are some. I will add more, when I complete the compilation 1. What is OLTP(Online Transaction Processing)? OLTP stands ...