IF OBJECT_ID('dbo.VOrders') IS NOT NULL
  DROP VIEW dbo.VOrders;
GO
CREATE VIEW dbo.VOrders
AS
SELECT O.OrderID, O.OrderDate, O.CustomerID, O.EmployeeID, O.ShipVia,
  SUM(OD.Quantity) AS Qty,
  CAST(SUM(OD.Quantity * UnitPrice * (1 - Discount)) AS DECIMAL(12, 2)) AS Value 
FROM dbo.Orders AS O
  JOIN [Order Details] AS OD
    ON O.OrderID = OD.OrderID
GROUP BY O.OrderID, O.OrderDate, O.CustomerID, O.EmployeeID, O.ShipVia
GO

SELECT EmployeeID,
(
 (SELECT MAX(Value) FROM
   (SELECT TOP 50 PERCENT Value FROM dbo.VOrders AS O1
    WHERE O1.EmployeeID = E.EmployeeID
    ORDER BY Value) AS H1)
 +
 (SELECT MIN(Value) FROM
   (SELECT TOP 50 PERCENT Value FROM dbo.VOrders AS O2
    WHERE O2.EmployeeID = E.EmployeeID
    ORDER BY Value DESC) AS H2)
) / 2 AS Median
FROM dbo.Employees AS E
order by E.EmployeeID

WITH OrdersRN AS
(
  SELECT EmployeeID, Value,
    ROW_NUMBER() OVER(PARTITION BY EmployeeID ORDER BY Value) AS RowNum,
    COUNT(*) OVER(PARTITION BY EmployeeID) AS Cnt
  FROM dbo.VOrders
)
SELECT EmployeeID, AVG(Value) AS Median
FROM OrdersRN
WHERE RowNum IN((Cnt + 1) / 2, (Cnt + 2) / 2)
GROUP BY EmployeeID;

quote:

---

Originally posted by Asi

I have never written any CLR user defined function or any code in .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.

I have experience in T-SQL and VBA Programing.

Do you have a good reference to start with. I need to start with the working / programing environment, installations that I need etc...

The code itself and syntax will come along the way.

Thanks
Asi

---