Other SIN SQL function

1. Usage of SIN to show Sales by Order Date

SQL Server Query 1

            
 SELECT  

     o.OrderID,  

     o.OrderDate,  

     -- Calculate the day of the year (1-366)  

     DATEPART(DAYOFYEAR, o.OrderDate) AS DayOfYear,  

     -- Convert day of year to an angle in radians (2*PI represents a full year)  

     (DATEPART(DAYOFYEAR, o.OrderDate) / 366.0) * 2 * PI() AS OrderAngleRadians,  

     SIN((DATEPART(DAYOFYEAR, o.OrderDate) / 366.0) * 2 * PI()) AS SineOfOrderAngle,  

     SUM(od.Quantity * od.UnitPrice) AS TotalSales  

 FROM Orders o  

 JOIN [Order Details] od ON o.OrderID = od.OrderID  

 GROUP BY o.OrderID, o.OrderDate  

 ORDER BY o.OrderDate;  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns("o.OrderID", "o.OrderDate")  

     .Column(new DATEPART(SqlDateInterval.dayofyear, new Column("o.OrderDate")), "DayOfYear")  

     .Column(new ColumnArithmatic().StartBracket(new DATEPART(SqlDateInterval.dayofyear, new Column("o.OrderDate")))  

         .DIVIDE(366.0).EndBracket().MULTIPLY(2).MULTIPLY(new PI()), "OrderAngleRadians")  

     .Column(new SIN(new ColumnArithmatic().StartBracket(new DATEPART(SqlDateInterval.dayofyear, new Column("o.OrderDate")))  

         .DIVIDE(366.0).EndBracket().MULTIPLY(2).MULTIPLY(new PI())), "SineOfOrderAngle")  

     .Column(new SUM(new ColumnArithmatic("od.Quantity").MULTIPLY("od.UnitPrice")), "TotalSales")  

     .From("Orders", "o")  

     .Join(new List<IJoin>()  

     {  

         new INNERJOIN().TableName(new Table("[Order Details]","od"))  

             .On(new Column("o.OrderID").Equale(new Column("od.OrderID")))  

     })  

     .GroupBy(new GroupBy(new Column("o.OrderID"), new Column("o.OrderDate")))  

     .OrderBy(new OrderBy().Set(new Column("o.OrderDate")))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT o.OrderID,
       o.OrderDate,
       DATEPART(dayofyear, o.OrderDate) AS DayOfYear,
       (DATEPART(dayofyear, o.OrderDate) / @pMAIN_2507192101282690300) * @pMAIN_2507192101282690301 * PI() AS OrderAngleRadians,
       SIN((DATEPART(dayofyear, o.OrderDate) / @pMAIN_2507192101282690302) * @pMAIN_2507192101282690303 * PI()) AS SineOfOrderAngle,
       SUM(od.Quantity * od.UnitPrice) AS TotalSales
FROM Orders AS o
     INNER JOIN
     [Order Details] AS od
     ON o.OrderID = od.OrderID
GROUP BY o.OrderID, o.OrderDate
ORDER BY o.OrderDate ASC;


            
        

Parameters (If used)

Query Results 1: