Search results for query: *

Sorry the column name is description. When I run the query as I have it written I get cases with a date of 07/07/2008. I am expecting to get ones dated 06/25/2008 (minus the business and 4th of July holiday. Thank you.

There are only 2 columns and sample data. holiday (datetime) desc (varcharw2(35)) 01/01/2008 00:00:00 New Year's Day 01/21/2008 00:00:00 Martin Luther King, Jr. Day 02/18/2008 00:00:00 President's Day 05/26/2008 00:00:00 Memorial Day 07/04/2008 00:00:00 4th of July 09/01/2008 00:00:00 Labor...

Now they came back and also want to exlude our Holidays from the days as well. We have a table created that lists the holidays. I have tried this but it is not giving me the right dates again. Here is the query. select mem_id, cme_hmp_code, cme_date_begin from cme_case_management_episode...

Thank you Dagon, that worked, I appreciate the help.

Our business days are Monday thru Friday.

I have this query which pulls all the cases that are 14 calendar days old....I do not know how to change calendar to business days. So for example if I run the query as it is...I get all case with a date of 06/30/2008 but need the ones with a date of 06/25/2008. Posted is the query can...

Thanks to taupirho, I took your query and revised it somewhat and was able to come up with what I needed. Here it is: select lob_desc from ( SELECT LOB_DESC, row_number( ) over (partition by mpg_mem_uid order by lob_desc desc) rn FROM MPG_MEM_PLAN_GROUP, OPP_ORG_PAYER_PLAN...

I want it to always pick Medicare when that line exists or if only 1 line exists display just that line. So for instance Member # 1 has on Medi-cal but Member # 2 has both Medicare and Medi-cal. In this instance if I was choosing member#1 then Medi-cal would be displayed. If I choose...

I have a query that will pull a member's line of business desc from their current eligibility sequence. In most cases the members have only 1 current sequence, however we have a subset of the population that will have 2 current sequences. In this case when the member is chosen, if they have 2...

CoSpringsGuy you are correc. The range being referred to is the eligibility range to return based on the single parameter date input by the user.

Aside from the parameter is it possible to group the date together to show the different periods?

The end user does not know the end date without looking it up. They are taking phone calls all day long from members and are on a quota for how many calls they must answer, they try to make there workflow as streamlined as possible. That is why they would like the end date to populate...

I have report that I need to choose a range of eligibility records based on a date parameter. I would like to display the min start date and max end date for each period of eligibility if there is no status change and no break in consecutive months of coverage. I am using Crystal XI and Oracle...

Thank you for responding. That helped ,but I do have a few members that have only 1 record...how can I supress those as well.

I need to compare the first 2 records for each member in a file that has multiple records. I only want to show where the status in record 1 has changed from record 2. A sample is listed below. I am using Crystal Report XI. ID# Name Status Eff Dat Term Dt Plan 12345 DOE,JANE A 20060301...

Does anyone know how to pass a parameter from a application built with power builder and using oracle to a crystal report? I need to pass a member id from a window the user has open to a report that is accessed when the user clicks a button on the window. The report is opened with Crystal...