I am trying to create a QVD as a slowly changing dimension, but I am struggling a little. I am able to store the current value and the one before that. However if there are more than 2 changes, the first value is no longer visible.
What I am trying to do now is to find the current record and store that as a resident. Any suggestions? I created a key for using the group and max functions, but I am unable to use that value in the where clause to put back the complete recordset.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
