Hello, thank you. Is there a reason why the SQL activity is not a good option for something like this? what would typically be a good use for the sql activity then? thanks!

Hello, thank you. Is there a reason why the SQL activity is not a good option for something like this? what would typically be a good use for the sql activity then?

Thank you so much for taking the time to reply. in regards to comment #2: How can we apply the recalculation of typology rules during the send out? That's what I would like to implement, however when going through the available configurations in typology rules I don't see that option.  Thank you. 

Thank you this was helpful!

is there a better way of doing this since its coming from a recurring delivery?

The workflow is running but I do get at least one or more deadlocks a day. so im constantly having to go back and start them up again. we do have message center set up on our dev environment. but I'm not very sure how to use it. it seems like we may be able to get some good use out of it, but the ex...

How would I check to see if there is a record or not using the test activity? I like this idea as I was thinking to myself, not every cycle will have a result. so if there are no results this time 'end' query. but when I select conditions under the test activity not sure what field to use?Thanks!

Thank a lot all! it worked in 18 seconds now!

UPDATE: IT RAN! however, it took 9 minutes to do so. I figure there is probably a more efficient way of doing this.

Thank you for your prompt reply. I removed the additional 'recipient delivery log exist' line and ran it again, but no dice. the query is staying in limbo with the gear at the top running. Like you mentioned the query regarding the event date seems correct. in fact, when I hard code the dates I get ...