Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --WBS_TASK_STRING ACTIVITY_ID FROM_DATE TO_DATE #OCCURENCES
- /* SQL STATEMENT
- select wbs_task_string, activity_id, from_date,to_date, count(*) occurences from wbs_task
- where activity_id is not null
- group by wbs_task_string, activity_id, from_date,to_date
- having count(*) > 1
- order by 1;
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement