Results 1 to 3 of 3
Hybrid View
-
17th February 2011 21:50 #1
!
, :
stored Northwind db, ( ). C#, stored , , record set.
C# . stored . SQL , , .
.
!Code:CREATE PROCEDURE sp_FindSupplierIncomes (@dateBegin DATETIME, @dateEnd DATETIME, @supplierName nvarchar(50)) AS BEGIN SELECT s.SupplierID FROM Suppliers s JOIN Products p ON s.SupplierID = p.SupplierID DECLARE @unitsSum INT = p.UnitsOnOrder * p.UnitsOnOrder SELECT od.OrderID FROM OrderDetails od JOIN Products p ON p.ProductID = od.ProductID JOIN Orders o ON o.OrderID = od.OrderID IF(@dateBegin > o.OrderDate AND @dateEnd < o.ShippedDate) PRINT unitsSum END
.. SQL
-
18th February 2011 10:44 #2, .Code:
CREATE PROCEDURE sp_FindSupplierIncomes (@dateBegin DATETIME, @dateEnd DATETIME, @supplierName nvarchar(50)) AS BEGIN SELECT s.SupplierID, sum(p.UnitsOnOrder * p.UnitsOnOrder) FROM Suppliers s inner join Products p ON s.SupplierID = p.SupplierID inner join [Order Details] od ON p.ProductID = od.ProductID inner JOIN Orders o ON o.OrderID = od.OrderID where s.CompanyName like @supplierName and @dateBegin > o.OrderDate AND @dateEnd < o.ShippedDate group by s.supplierID END
: XaMaB; . 0.42
In God we Trust (all others must submit a X.509 certificate). , ()
-
18th February 2011 15:01 #3




Reply With Quote
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in