هذا البروسيجر كامل وبعد ما احط رقم الموظف ما يجيب القيم مع ان يوجد موظف يحمل هذا الرقم
CREATE Procedure [Employee_View]
(@Employee_ID_1 [int])
AS SELECT dbo.Employee.Employee_Name_A, dbo.Employee.Department, dbo.Employee.Director_In_Charge,
dbo.Employee.Jobtitle, dbo.Employee.Date_Of_Appointment, dbo.Employee.Nationality, dbo.Photo.Photo, dbo.Salary.Basic_Salary,
dbo.Salary.Accomadotion, dbo.Salary.Life_EX, dbo.Salary.Transport, dbo.Salary.Another, dbo.Salary.Total, dbo.Discount.Discount_Amount,
dbo.Extra.Extra_Amount, dbo.Loan_Description.Loan_Amount, dbo.Loan.Loan_Installment, dbo.Loan_Amount.Amount,
dbo.Loan_Amount.Way_Pay_Amount
FROM dbo.Extra INNER JOIN dbo.Discount INNER JOIN dbo.Loan INNER JOIN dbo.Loan_Amount ON dbo.Loan.Loan_ID = dbo.Loan_Amount.Loan_ID INNER JOIN dbo.Loan_Description ON dbo.Loan.Loan_ID = dbo.Loan_Description.Loan_ID INNER JOIN dbo.Employee ON dbo.Loan.Employee_ID = dbo.Employee.Employee_ID ON dbo.Discount.Employee_ID = dbo.Employee.Employee_ID ON dbo.Extra.Employee_ID = dbo.Employee.Employee_ID INNER JOIN dbo.Salary ON dbo.Employee.Employee_ID = dbo.Salary.Employee_ID INNER JOIN dbo.Photo ON dbo.Employee.Employee_ID = dbo.Photo.Employee_ID
WHERE (Employee .Employee_ID= @Employee_ID_1)
GOاذا ممكن اعرف وين الخطاء
