Solved

How can I incorporate this function into the attached query

Posted on 2010-08-27
1
356 Views
Last Modified: 2013-12-07
Hi There,

I have the attached query which is a report from a billing application and below is a description of a function that was used to run the report. How can the report be modified to include the functionality of the function in the second file?



Thanks,
R
Report.txt
Function.txt
0
Comment
Question by:Rhonda Carroll
1 Comment
 
LVL 4

Accepted Solution

by:
mottor earned 500 total points
ID: 33543457
Replace in query this:

:PARMMSGTYPE  ->  decode(:PARMMSGTYPE,'ALLC','ALL',:PARMMSGTYPE)
:PARMNETWORK  ->  decode(:PARMMSGTYPE,'ALLC','C','POS','C',:PARMNETWORK)
:PARMVESSELSORT ->nvl( (SELECT VESSEL_SORT FROM TCUSTOMR,INVOICE WHERE INVOICE.INVOICE_NUM = :PARMINVOICENUM AND INVOICE.CUSTOMER_CODE = TCUSTOMR.CUSTOMER_CODE AND ROWNUM = 1),:PARMVESSELSORT)
:PARMREPTITLE ->  decode(:PARMMSGTYPE,'ALLC','for Inmarsat C','POS','for Inmarsat C Data Reports','for All Services')



0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need help constructing a conditional update query 16 71
SQL Syntax 24 46
Checking for column width 8 29
Toad 12.10 Enterprise visual interface 4 22
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question