Hi, I am trying to get the earliest start time of the latest plan that the person took. In the following, the latest plan is P1, and the earliest start date of it is 06-Feb-2015 . It should therefore return P1 , 06-Feb-2015 ID Date Plan Bundle 100 03-Jan-2014 P1 12 100 13-Oct-2014 P2 07 100 21-Dec-2...

Hi, to simplify what Im trying to do.. I have a script as follows which extracts info for a.FPR_SERV_NO by month. Some months have no data for the FPR_SERV_NO. I want to flag those as removals, and if it is added back, I want to flag it as an addition. Also the first time it is added, I want to flag...

Hello! I am trying to determine the most efficient way to find Additions and removals. The key field is fpr_owning_acct_no||FPR_SERV_NO||FPR_PRODUCT_CODE , and I am using Lead and Lag functions to determine if this key was added or removed by month. However I don’t think I am doing it the most effic...

Hey! thanks for responding :) I tried it, but it gave the error that.. 'Column F.Call_Type does not exist'. I ended up having to do the following: select FV.* ,sum(FV.Duration) over (w_sub rows between unbounded preceding and current row) as duration_running_local From (select F.* ,CASE WHEN F.Dest_...

Hello! The following sql does a running total of 'Duration' for every Charged_MSISDN by month. It does a running total for every 'Call_Type'. However I only want a running total of certain 'Call_Type' with values 'CIN' and 'DIG'. Will appreciate any help. Thanks! select F.* ,CASE WHEN F.Dest_MSISDN_...

Hi skwa!

Thanks for all the info on First_value! Its great to see this working the way I wanted it to. (..I didnt even realise you posted this, but just came back to thank you for all the help already given)

Thanks again!

Hi sKwa, Thanks for the information provided, I was able to succesfully test the first_value Analytic Function separately. However I ended up adding the following (to the original sql in the previous thread): inner join (select cpp.owning_acct_no,cpp.serv_no, cpp.product_code ,MAX(cpp.inst_date) as ...