Hi

Jeff

Probably the last question, since you got everthing sort out for me, along with min(datevlue) and max(datevalue) for everysequence , i would like to get the corresponding 'Prd'. I...

Hi

Rog

You are the SQl Guru, Thanks a lot , i really appreciat it, it was just bugging my head since last week. Now only job is to trap the begining...

Hi

Rog, Jeff

I have problem running this statement

SELECT A.ID,A.DateValue,A.Prd,A.Statusid,

Sum(CASE WHEN B.Statusid=2 THEN 1 ELSE 0 END)

OVER(ORDER BY A.ID

...

Hi

Rog

Thanks for your input on this!

Is there any other way to get this result without using RAC? thats the exact result that i was looking

for . I am using sql2k5...

Hi

Gsquared

i copied the previous data from sql pane and they are not aligining to each other, i think you can

estimate its order. Please let me know if its not...

Hi

GSquared

After runnig your both the query, for set and sequece, this is what i got

ID DateValue ...

Hi

Gsquared

Setfirst still missing the tag even after chaning the first query and even SetLast is taging on some place and not in other!

Thanks

Simon

Hi

Gsquared

Your first query for SetFirst and Set last was tagging the setfirst to the record just before the setlast (stausid=2) but i was looking for it to tag for the...

Hi

Jeff,Gsquared

Thanks for giving me the best suggestions that helped Gsquared to provide me the outstanding logic for my task. It was my first time posting and i was quite skeptical...