Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. paljnad

    Adding date to end of line in fixed length file

    I have a file that has data in a fixed-length format like this: 01/29/2010 INT CN 01/29/2010 NAT CN 01/29/2010 TSS CN And I want the output to be: 01/29/2010 INT CN 08/17/2010 01/29/2010 NAT CN 08/17/2010 01/29/2010 TSS CN 08/17/2010 Basically, I would like to append current date to the...
  2. paljnad

    Using default values with 'Allow multiple values'

    I have a crystal report v 10.0 within which I have setup a string parameter called 'AccountNumber'. Under 'Edit Parameter Field' - I have checked the 'Allow multiple values' option and also checked the 'Discreet Values' button. And then under default values, I have typed in 'All'. In my report...
  3. paljnad

    Converting multiple rows into a single row

    Will do. Thanks for all your help.
  4. paljnad

    Converting multiple rows into a single row

    Thanks again, taupirho. I was able to modify the query a little bit to get it work and it works beautifully. I am also able to generate a text file output but when I copy and paste from the text file into the 'To' field of my email message then I notice that there are new line characters...
  5. paljnad

    Converting multiple rows into a single row

    Thanks, taupirho. I tried it but it gave me an ORA-01489: result of string concatenation is too long error message. I am pretty sure that the length of the string returned by the select statement is over 4000 characters.
  6. paljnad

    Converting multiple rows into a single row

    Hello, I have this query that returns all the valid email addresses from a table on the database: SELECT distinct trim(user_email_address) || ';' FROM table a WHERE active_status <> 0 and user_email_address is not null ; The records returned are in the following format: abc@ws.com...
  7. paljnad

    Writing out meaningful output

    Hello, We currently have some SQL code that we call from another BAT file but the log file produced from this process does not have any meaningful information. For example, we have a command file that has this line: C: c:\Oracle\10.2.0\bin\SQLPLUS.EXE UID/PWD@DB @e:\a.sql >e:\a.log a.sql...
  8. paljnad

    Calculating next business day

    Thanks, lbass. I was able to use formula 17 to get what I wanted.
  9. paljnad

    Calculating next business day

    Thanks, Madawc. But I just want to be able to get the next business day. If today was 9/1 then the next businessday is 9/2 and if today was 9/4 then the next businessday is 9/8 since 9/7 is a holiday.
  10. paljnad

    Calculating next business day

    Hello, I have a Crystal Report v 10.0 that has dates and the balances for that day in the detail section and it is grouped by account number and date so it looks like this: Acct Num: 1234 9/1 1000.00 9/2 134.56 9/3 877.34 9/4 3444.44 9/8 635.78 Acct Num...
  11. paljnad

    'Change Group' performance issues

    I have crystal report developed in v 10.0 and it has 4 groups and all headers except GH2 are suppressed. When I right-click and select 'Change Group' for GF3 and then click on 'Specified Order' then the report seems to hang - it takes a lot of time for the data to come back up. And then when I...
  12. paljnad

    Passing values from subreport to main report

    Thank you both for your responses. I used a link and was able to get the data that I wanted. I used a couple of formulas and variables in the main report to display the total by all company codes from the subreport. I put it in the group footer of the main report.
  13. paljnad

    Passing values from subreport to main report

    Hi, I have a main report that has company code values and I have a subreport that has totals in the {GF by company code}section. I need to pass the total from the subreport to the main report based on company code. My main report looks like this: RH - Suppressed PH - Report Headings...
  14. paljnad

    rows data to columns

    Thanks, SantaMufasa. I tried it but for some reason, it puts duplicates out there. Also, how do I join in another table. The query I have now is: select anumber, ltrim(substr(max(sys_connect_by_path(bu_code, ', ')), 2)) BU_CODE from (select anumber, bu_code...
  15. paljnad

    rows data to columns

    I have the following query: select a.anumber, (case when b.bu_code = 'DIST' and b.req_flag = 'R' then 'TRUE' else ' ' end) as DIST, (case when b.bu_code = 'BCTR' and b.req_flag = 'R' then 'TRUE' else...
  16. paljnad

    decode in WHERE

    Thanks, Santa. I used the decode and it worked like a charm !
  17. paljnad

    decode in WHERE

    I have a query that joins two tables based on column A. select * from table a, table b where table a.column a = table b.column a Column A in table A has a value of 'SEP A' Column A in table B has a value of 'SEP_A' How do I put a decode in the where statement so that it does a correct...
  18. paljnad

    Exporting to a CSV file output

    I tried this and it ran without any errors: select datasource || ',' || contno || ',' || tranno || ',' || tranmode || ',' || trantype || ',' || trantypedescription || ',' || primarycurr || ',' || bunit || ',' || bunitshortname || ',' || bunitfullname || ',' || cpty || ',' ||...
  19. paljnad

    Exporting to a CSV file output

    The select count(*) from..worked so now I am going to try and add back all the segments in steps to see where I get the error.
  20. paljnad

    Exporting to a CSV file output

    Hi Mufasa, The tables are part of a vendor package and they directly gave the create and insert script to the DBAs and not to the app people. We are just trying to figure out a way to get the data out of the tables in CSV format.

Part and Inventory Search

Back
Top