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 IamaSherpa 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: cbochner
  • Order by date
  1. cbochner

    Cognos 8 Substring Function - Really Slow

    Hi, I'm just wondering whether anybody in the forum has experienced a decline in report execution when using Substrings. A report that would generally run in a minute without Substring, runs forever with Substring. Please Help... C.B.
  2. cbochner

    Pattern Formation for Phone Numbers

    Hi, What is the formatting pattern to display a 10 digit phone number as (###) ###-####. Please Help, Chaim Bochner
  3. cbochner

    Nested LEFT and INNER Joins

    Hi, I have a join sequence as follows: from stoordre a LEFT JOIN bhrcustc b ON a.cust_code = b.cust_code LEFT JOIN bhroapsd child ON a.cust_code = child.cust_code INNER JOIN bhroapse parent ON child.p_code = parent.p_code INNER...
  4. cbochner

    Excel Output Row Limitation

    HI, I'm running a report output to CSV. I would like to load this data into Excel but Excel has a 65,000 row limitation. Any Ideas? Thank You,
  5. cbochner

    CASE Statement in a Where Clause Problem

    Thanks guys for all your help. It worked just fine... Chaim
  6. cbochner

    CASE Statement in a Where Clause Problem

    So how do I setup a conditional statement in a where clause in SQL? How do I say: if today is monday query x..., if today is not monday y...? Thanks, Chaim
  7. cbochner

    CASE Statement in a Where Clause Problem

    dre.l_mod_datetime >= to_char(today-4,"%Y-%m-%d") || ' 18:00' is a conditional statement not an expression. igamine... Where x = y and dre.l_mod_datetime >= to_char(today-4,"%Y-%m-%d") || ' 18:00' instead... CASE WHEN x = y THEN and dre.l_mod_datetime >= to_char(today-4,"%Y-%m-%d") || '...
  8. cbochner

    CASE Statement in a Where Clause Problem

    Hi, I'm trying to write the following SQL code with lots of problems. Please Help... Select * from [table] where CASE WHEN dte.weekday_no = 2 THEN dre.l_mod_datetime >= to_char(today-4,"%Y-%m-%d") || ' 18:00' ELSE dre.l_mod_datetime >= to_char(today-2,"%Y-%m-%d") || '...
  9. cbochner

    Help wit Union SQL

    Hi, I'm trying to return a single record usin a UNION as Follow: SELECT '' AS customer_code, '' AS Cust_Bus_name, '' AS Bill_Buss, '' AS Bill_Contact, '' AS Billto_phone, '' AS Bill_Add1, '' AS Bill_Add2, '' AS Bill_City, '' AS...
  10. cbochner

    Using VBA to iterate folders and return Email Address

    Hi, I'm trying to write VBA code to iterate all folders and extract the senderemailaddress (not the sendername). I have Outlook version 2002 which does not support senderemailaddress. Please help. Thank You, Chaim Bochner
  11. cbochner

    Instr Function

    Hi Again, Is there a capability in ReportNet 8 to program? For instance, I would like to find the last "." in an e-mail address, so I can grab the last part of the e-mail address and present it into a drop down list. Can such a thing be done? Please Help. Chaim Bochner
  12. cbochner

    Instr Function

    Hi, Is there a feature that you can find a position in a string based on a string search? Fo instance: Email: john.doe@yahoo.com Is there a function I can use in cognos to retrieve the "com" from the string? Please enlighten me. Thank You C.B. :)
  13. cbochner

    instr like function in SQL

    Hi, Is there a way to find a string within a strin in SQL the same way you do it in VB (Instr)? I'm wracking my brain and can't seem to find anything helpful yet.

Part and Inventory Search

Back
Top