I have a sql in the "data input" and is set to run at a particular frequency (may be 120 minutes or 1200 minutes or even 10 minutes) .The data input has a sql. the sql typically retreives 200+ rows (may vary every time the sql gets run). So, for e.g. the data input sql ran at 8 am -> gave 200 rows. the data input sql ran at 10 am -> gave 300 rows. the data input sql ran at 12 -> gave 400 rows. I want the set of 400 rows that was most recently run. Depending on the most recent result set (i.e. 400 rows) -> i would like to do some group by & where and embed that search in the xml. ... View more