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 Rhinorhino 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. teddysnow12

    Grouping based on maximum value

    hi all, clm_nr clm_status eff_dt amt ------- ----------- ---------- ------ 910774617 closed 7/5/2009 0.00 910774617 active 6/21/2009 621 910774617 active 6/21/2009 131 this is grouped by clm_nr...
  2. teddysnow12

    How to remove Zeros after decimal

    Hi, I have numbers like 11.00 , 13.00 I need to remove the zeros and want the numbers look like 11 , 13. I want help in writing the formula for this in crystal reports 2008. Thanks!
  3. teddysnow12

    Number to string conversion

    Hi, I have a field , end_yr_mnth which has a value like 201103 (datatype is number) I have other field rptg_yyyymm which has a value like 2011-03 (datatype is string and format is yyyy-mm) I need a syntax for converting either number into string or string into number to match these two fields.
  4. teddysnow12

    Case statement

    Hi, The following is my code, select sum(mms.plcy_holdr_mnth_cnt) as curre , 'Enrolled Employees' as measure from mbr.mbr_mnth_fact mms , mbr.mnth_dim mt, mbr.PRDCT_dim_old pd , mbr.grp_structr_dim gsd , cmrcl_wlns.grp_dim@HM_LINK gd where mt.yyyymm_cd = MMS.RPTG_YYYYMM and...
  5. teddysnow12

    Need syntax for 1 year prior the given date

    Hi, I need a syntax which gives 1 year prior to a given year . My field is rptg_yyyymm. the datatype is string. example : The values are like this, '2008-01' '2008-02' I should convert this into date format and also need syntax for 1year prior this date like, if the given year is 2008-01...
  6. teddysnow12

    How to get 1 year prior in SQL

    Hi, I need syntax in SQL to get 1 year prior for a given year. Thanks!
  7. teddysnow12

    convert a given year into number format

    Hi, I have a year field like rptg_yyyymm. I need to convert it into number format in SQL. Can anyone give me the syntax for this in SQL. the number should like this, for example if the year is 2008-10 it should look like 200810 Thanks!
  8. teddysnow12

    Crystal formulae

    Hi, I have to create a table in crystal like, | current | prior |change(cu-pr) | | | Employees | | | Members | | | average age | | | %females | | | %males...
  9. teddysnow12

    Error in SQL

    Hi, when I try to add SQL query to command window in Crystal, it is throwing an error , ORA:01008 NOT ALL VARIABLES BOUND Can anyone help to rectify this error. Thanks!
  10. teddysnow12

    formula for truncating.

    Hi.. I need a formula for truncating first two zeros of each number in series of numbers. my numbers lokk like this: group ids : 0046854 , 0083669 ,0097787 Thanks!

Part and Inventory Search

Back
Top