I am looking for a script and sql statement to close certain requests. All requests in a certain group that have all tasks completed (there can be up to 30 tasks) and not in a waiting for approval status. I want to add "Closed Complete" to the resolution field and close the ticket.