Search results for query: *

Could you please explain in detail. Thanks

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

It worked! Thank you

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.

I need help in writing the syntax for the mt.yyyymm_cd to go 1 year prior. in the code I used static values like 2011-03 and 2010-03. But I want as parameters which user can enter. these are dates but they are in string format.

Thank you, It worked!

measure current prior enrolled members 300 216 This is the way I want the result. Here current represents the 2011-03 and prior represents the 2010-03 ( 1 year prior)

Thanks for your response, but I need them as 2 different results. one for 2011-03 and one for 2010-03

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

It is working. Thanks a lot.

thank you for you response. but it is throwing an error saying ' Missing expresssion' and pointing at varchar

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

I will post the questions in SQL threads. sorry for inconvinience.

it is saying that dateadd is an invalid identifier. The field related to this is rptg_yyyymm. and teh value is like this '2008-10' (yyyy-mm) the datatype is string. do you think first i need to convert it into date format and then calculate the prior year?

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

Thank you guys for your valuable answers. helped me a lot.

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!

I need to fill in the values as, current employees prior employees change(cur-pro) employees current members proir members change menbers and so on.. these values get generated based on given parameters like rptg_yyyymm(year) ftn_nbr_nme(customer name) and so on prior basically depends...

current ------ prior------- change ----------------------------------------------- employees ----------------------------------------------- members ----------------------------------------------- average age ----------------------------------------------- females...