Popular Posts
Join related table and count rows or sum sql server 2005 count rows: SELECT * FROM Table1 LEFT JOIN     (SELECT Level1ID, COUNT(Level2ID) AS Total FROM Table2 GROUP BY Level1ID) AS... Remove file not in list ADD ... THEN ... UNTIL ... data: begin of SERIES, N1 type I value 10, N2 type I value 20, N3 type I value 30, N4 type I value 40, ...
Stats
Loop execution of workflow

1. Create the first workflow as a trigger. This workflow will start another workflow by update current item as last action. Pause for 5 minutes is to avoid parallel execution.

2. Create the second workflow which do some action and update current item for continue loop. In this case, these two workflow will execute every day and check for status and sending mail.