CREATE view  View_Issue_to_Issue_WF AS SELECT View_Issue.*, isswf.id wf_id, isswf.persid wf_persid, isswf.del, isswf.object_type, isswf.object_id, isswf.task, isswf.wf_template, isswf.sequence, isswf.status wf_status, isswf.group_task, isswf.asset, isswf.creator, isswf.date_created, isswf.assignee wf_assignee, isswf.done_by, isswf.start_date wf_start_date, isswf.est_comp_date wf_est_comp_date, isswf.est_duration, isswf.completion_date, isswf.actual_duration, isswf.est_cost wf_est_cost, isswf.cost, isswf.description wf_description, isswf.last_mod_dt wf_last_mod_dt, isswf.last_mod_by wf_last_mod_by FROM ( View_Issue inner join  isswf ON View_Issue.persid = isswf.object_id)
GO
GRANT SELECT ON  [dbo].[View_Issue_to_Issue_WF] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_Issue_to_Issue_WF] TO [service_desk_ro_group]
GO