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 bkrike 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: *

  • Users: cli
  • Content: Threads
  • Order by date
  1. cli

    Dat format problem using Crystal Reports 8.5 & Oracle 8i

    Hi, I am using Oracle 8i and crystal reports 8.5. I have several reports which are populated by procedures from on the database. These procedures substring a date for use in if statements and concatenates it back together for a parameter. For some reason this works fine on my machine but not...
  2. cli

    oracle sql question

    Hi, I would appreciate any help with this please ! I am trying to make the sql below more dynamic SELECT TB_NAT.CL_NAT, SUM(DECODE(TB_BAT.DE_STATUS,'JR',1,0)) AS JR, SUM(DECODE(TB_BAT.CL_GENDER_CODE,1,1,0)) MALE, SUM(DECODE(TB_BAT.CL_GENDER_CODE,2,1,0)) FEMALE FROM tb_BAT, TB_NAT WHERE...
  3. cli

    dynamic sum decode

    Hi, I would appreciate any help with this please ! I am trying to make the sql below more dynamic SELECT TB_NAT.CL_NAT, SUM(DECODE(TB_BAT.DE_STATUS,'JR',1,0)) AS JR, SUM(DECODE(TB_BAT.CL_GENDER_CODE,1,1,0)) MALE, SUM(DECODE(TB_BAT.CL_GENDER_CODE,2,1,0)) FEMALE FROM tb_BAT, TB_NAT WHERE...
  4. cli

    sql if table exists drop table using srw.do_sql !!!

    Hi, would totally appreciate help..new to sql I am tyring to check if a table exists from trigger in oracle reports before creating it. My code complied fine but has an error saying command not ended properly when irun it. code: ******************************************************...
  5. cli

    sql SUBTRACTING TWO SUMS

    HI ! I am trying to subtract the sum of two different columns on two different tables from each other. If I write my sql as: Select sum(table1.column1- table2.column2) from table1, table2; I get the wrong answer it subtracts the columns before summing them. So now I have created a stored...

Part and Inventory Search

Back
Top