| Yes, but what are the advantages over SQL? I did quite a bit of SQL in my last job, and I can't think of a single case where I wish I had a pipeline operator. If I wanted to do something similar to the example on your homepage the simplest way is just to use subqueries. Here's a rewrite of your query in T-SQL... ------------------------------------------------------ SELECT EMP.Country, EMP.LastName, EMP.FirstName, OD.OrderID, ORD.ShippedDate, OD.SaleAmount FROM (SELECT TOP 10 T1.OrderID, T1.ORDSUM
FROM
(SELECT OrderID, SUM(UnitPrice * Quantity * (1 - Discount)) AS SaleAmount
FROM "Order Details"
GROUP BY OrderID) AS T1
ORDER BY T1.ORDSUM DESC) AS OD LEFT JOIN Orders AS ORD ON OD.OrderID = ORD.OrderID LEFT JOIN Employees AS EMP ON ORD.EmployeeID = EMP.EmployeeID ------------------------------------------------------ That's fairly concise, and was quick to bash out. I'd wager it could be made even smaller if I used LINQ instead of SQL. Perhaps your method has some advantages in other types of query? How do you see it? |