Hi,

For my above requirment i want,

dq_cycle_cnt.:

Every time a district reach qualification status , cycle time should set a count +1 to the previous count.

So for...

Ya its working but I have many district so what can I do? and I want to show all columns as I have mentioned in my SQL.

So please do the...

its just geting the rank i have added what I want means my requirment in details

hi,

My requirement is to show the value in the dq_cycle_cnt column on the basis of

the column dq_prev_status_cd i.e.,

when the dq_org_dist_id first value would be null or Draft will be

1...

Hi,

Yes i want data as like you have mentioned..So can you help me how can I impliment in my below sql,

WITH q AS (

SELECT

...

I have tried but not getting the proper result.

HI

here is my sql which i hvae written

I have included only two district id for the testing purpose.

WITH q AS (

SELECT

dq_src_id

...

Thanks all for helping me out of this issue.

Yes both columns having index.

So please suggest me what should be hints can I use to get result fast.

Hi,

I have provided the sample in my first reply.

Hi,

I write the code to update the table, but I am facing problem i.e.

when I am going to execute the below SQL it taking long time while updating the table...

Hi,

I write the code to update the table, but I am facing problem i.e.

when I am going to execute the below SQL it taking long time while updating the table...

Hi,

The first two Active records having two dofferent dates i.e.

org_club_status org_rec_eff_dt org_status_change_dt

Active 1988-07-01 1988-07-01

Active ...

Hi,

thanks for the reply.

your are correct.

we have function in sql server IDENT_current but its giving the current value from the table

But i have a requirement to insert a new row...

thannks for you help definetly I will help yo