Delete from hib.[workflowtemplate]


SET IDENTITY_INSERT  hib.[workflowtemplate]  ON

--NDS Workflow
Insert into hib.[workflowtemplate] (id, name, [description], groupid, [workflowtypeid])
values (1, 'NDS Workflow', 'NDS Workflow', 1, 2)

--SQDUG Workflow
Insert into hib.[workflowtemplate] (id, name, [description], groupid, [workflowtypeid])
values (2, 'Surgery Workflow', 'Surgery Workflow', 11, 4)

--OEF/OIF Workflow
Insert into hib.[workflowtemplate] (id, name, [description], groupid, [workflowtypeid])
values (3, 'OEF/OIF Workflow', 'OEF/OIF Workflow', 9, 4)


SET IDENTITY_INSERT  hib.[workflowtemplate]  OFF


--Select * from hib.[workflowtemplate] temp left join hib.workflowtype t on temp.workflowtypeid=t.id left join hib.[group] g on temp.groupid=g.id
