Thanks for given this , but in the script you are taking min date based on name .
But i want to take the minimum date based on ids 0 and 1 by same name.
1)If the same name having the other id like name(A) id(3) then it should take the minimum date from id s 0 and 1 and it should not take date form id 3 even if it is having the same name.
2)If the ids is not having the 0 then it should consider each row as different record even if it is having the same name,it should take minimum date of that date only .
3)if the ids is 0 and name is different then it should consider as each row as different record, it should take minimum date of that date only
I worked on your query, it took a little time as I had some other work. Please find the updated qvw attached. Go over script part, I have done data manipulation there to meet your requirements.
First I have separated table in two parts-one consisting id (0,1) and other consisting (rest of the ids). I did operation in first part and then concatenated it with the second part, as you don't want any change in rest of the ids.
Let me know if you get issue with script, I can explain. I am pretty sure that script could be made more precise.
