Re: How to replace the one date by another date and a number also?
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.