Search results for query: *

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

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!

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.

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

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

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

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!

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

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!

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!