my requirement is to identify the employees ( by emp no-pernr) who meet this criteria:
all employees who have a record in crt table ( cluster pcl2) with a cumulation type of 'y' in the calender year of 2007.
and write a list of these employees no to a file on the c: drive of the presentation server.
please help me its urgent.
points will be rewarded.