Hi,

Its worked...

Thanks for your help.

Kiran R

Hi,

It's worked.

Thanks for help.

Best Regards,

Kiran R

Hi,

I have implemented your logic in my code,its worked fine.

I did not get any end date which is less then start date.

Thanks for your valuable help for doing this.

Best Regards,

Kiran

Hi,

I have had used that condition start_date + 1 but my other end dates are coming wrong.

So request you to please suggest solution that I changed only that end dates.

Or...

Hi,

please find the below script with samle data this is coming now

CREATE TABLE tmp

(role nvarchar(20),

org_ID ...

Hi,

Sorry about this..

please find the below description below if this will work.

please consider District as a "org_ID"..

So District 1050 has a charter date (org_date_founded) of 1 January 1970. The earliest...

Hi,

from that above sql i took some records for your testing purpose.

Roleorg_IDMember_IDStart_DateEnd_DateOrg_Found_Datesequence_nbr

Club Secretary448531112006-07-01 00:00:002007-06-30 00:00:001935-03-04 00:00:00.0001

Club Secretary448531112007-07-01 00:00:002008-06-30 00:00:001935-03-04 00:00:00.0002

Club Secretary448531112009-07-01 00:00:002010-06-30 00:00:001935-03-04 00:00:00.0003

Club Secretary448531112010-07-01 00:00:002011-06-30 00:00:001935-03-04 00:00:00.0004.

I need to...

Hi,

please provide me any solution regarding my above concern it means i can impliment that logic in my sql

Regards,

Kiran

Hi,

Request you to please advise for my above SQL script and give me the solution to finding out my above concenr.

Regards,

Kiran R