الاخوة الزملاء
السلام عليكم ورحمة الله وبركاتة
عندي مشكلة في اجراء مخزن يعطني خطأ ولا استطيع تحديد سبب المشكلة فبرجاء مساعدتي في هذا الامر
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER Proc [dbo].[RptSupplierAccountDetails] @Supid int as begin SELECT dbo.Suppliers.Supid, dbo.Suppliers.Supplier, '0' AS securities ,HAdd_Doc, Trans.Depit , 0 AS credit , dbo.Suppliers.Home, dbo.Suppliers.Mobile, dbo.Suppliers.Job, dbo.Suppliers.address ,Trans.ZDate FROM dbo.Suppliers INNER JOIN ( select dbo.AddDoc.Supid ,ZDate,AddDoc.HAdd_Doc ,Sum (Convert(float, dbo.Transactions.GrandTotal)) AS Depit from dbo.Transactions INNER JOIN AddDoc ON AddDoc.HAdd_Doc = dbo.Transactions.DAdd_Doc Group By AddDoc.Supid,ZDate , dbo.AddDoc.HAdd_Doc ) as Trans ON Suppliers.Supid = Trans.Supid where (dbo.Suppliers.Supid = @Supid) Union all Select dbo.Suppliers.Supid,dbo.Suppliers.Supplier, dbo.AccountPayable.securities, '-' AS HAddDoc, 0 AS depit, Sum(Convert(float, AccountPayable.LE)) AS Credit, dbo.Suppliers.Home, dbo.Suppliers.Mobile, dbo.Suppliers.Job, dbo.Suppliers.address, dbo.AddDoc.ZDate FROM Suppliers --INNER JOIN AddDoc ON dbo.Suppliers.Supplier = AddDoc.Supplier INNER JOIN AccountPayable ON Suppliers.Supplier = AccountPayable.Supplier where (dbo.Suppliers.Supid = @Supid) Group by dbo.Suppliers.Supid,dbo.Suppliers.Supplier, dbo.AccountPayable.securities,dbo.Suppliers.Home, dbo.Suppliers.Mobile, dbo.Suppliers.Job, dbo.Suppliers.address, dbo.AddDoc.ZDate end exec [RptSupplierAccountDetails] 1
وهذا الخطا الذي يظهر لي
Msg 4104, Level 16, State 1, Procedure RptSupplierAccountDetails, Line 9 The multi-part identifier "dbo.AddDoc.ZDat" could not be bound. Msg 4104, Level 16, State 1, Procedure RptSupplierAccountDetails, Line 9 The multi-part identifier "dbo.AddDoc.ZDate" could not be bound.
وشكرا علي المساعدة

