10-08-2011 03:53 PM
I have a table called "test". It contains all the employment applications received. The dataset contains numerous rows for each application because each is reviewed by various people. I wrote a code create a dataset containing data when each application was first reviewed. Is there a way to do the same in query builder? Thanks!
10-10-2011 01:59 PM
Depends on how your source table look like (and how you solved in your program).
But if it can be solved in a single, fairly simple SQL, the chances are, yes, you might can.
If you have an application id, and a timestamp on each row which defines the time when the application was reviewed, you might do something like this: