CREATE PROCEDURE [dbo].[up_AccountItemSelectALL]
AS
SELECT a.AccountGuid, a.AccountCategory, a.AccountName, a.AccountFSCode, a.DICGuid, a.IsObsoleted, d.DepartmentName, d.DepartmentCode FROM dbo.T_AccountItem AS a
LEFT OUTER JOIN dbo.T_Department AS d
ON a.DICGuid = d.DepartmentGuid
ORDER BY a.AccountCategory
create proc up_DeleteEmp2DeptBYGuid
@EmployeeGuid uniqueidentifier
as delete from dbo.T_Emp2Dept where EmployeeGuid=@EmployeeGuid