04-10-22, 01:35 PM
السلام عليكم اخوانى
عندى اجراء مخزن Stored Procedure بيجلب لي بعض المعلومات وشغال تمام وهو كالاتي
كود :
select sum(TBL_Products_Received_Details.Quantity)as 'Total Received'
,Beginning_Inventory
,Product_Name
,Company
from TBL_Add_Products
inner join TBL_Products_Received_Details
on TBL_Products_Received_Details.Product_S_N = TBL_Add_Products.Product_S_N
where TBL_Products_Received_Details.Product_S_N=3013
GROUP BY TBL_Add_Products.Product_Name,TBL_Add_Products.Beginning_Inventory
,TBL_Add_Products.Company,TBL_Add_Products.Product_S_N,TBL_Add_Products.Product_typeكود :
select sum(TBL_Products_Received_Details.Quantity)as 'Total Received'
,Beginning_Inventory
,sum(TBL_Outgoing_Products_Details.Quantity)as 'Total Outgoing'
,Product_Name
,Company
from TBL_Add_Products
inner join TBL_Products_Received_Details
on TBL_Products_Received_Details.Product_S_N = TBL_Add_Products.Product_S_N
inner join TBL_Outgoing_Products_Details
on TBL_Outgoing_Products_Details.Product_S_N = TBL_Outgoing_Products_Details.Product_S_N
where TBL_Products_Received_Details.Product_S_N=3013
and TBL_Outgoing_Products_Details.Product_S_N=3013
GROUP BY TBL_Add_Products.Product_Name,TBL_Add_Products.Beginning_Inventory
,TBL_Add_Products.Company,TBL_Add_Products.Product_S_N,TBL_Add_Products.Product_typeشغال تمام ولكن قيمه ال ,sum(TBL_Outgoing_Products_Details.Quantity)as 'Total Outgoing بيتم ضربها في اثنين
وايضاً قيمه sum(TBL_Products_Received_Details.Quantity)as 'Total Received بيتم ضربها في اثنين
وايضا قيمه Beginning_Inventory بيتم ضربها في اثنين
بتمني حد يساعدني في حل المشكلة دي
شكراً مقدماً اخوانى