Other ATAN SQL function

1. Usage of ATAN to show directions in radians and degree

SQL Server Query 1

            
 WITH CustomerCoordinates AS (  

 	SELECT  

 		CustomerID,  

 		CompanyName,  

 		--  Simulated Latitude/Longitude difference from the central point  

 		(47.6062 + (ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) * 0.5)) - 47.6062 AS LatitudeDifference,  

 		(-122.3321 + (ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) * 0.8)) - -122.3321 AS LongitudeDifference  

 	FROM Customers  

 ),  

 DirectionCalculation AS (  

 	SELECT  

 		CustomerID,  

 		CompanyName,  

 		LatitudeDifference,  

 		LongitudeDifference,  

 		--  Calculate a simplified direction using ATAN  

 		ATAN(LongitudeDifference / LatitudeDifference) AS DirectionInRadians,  

 		DEGREES(ATAN(LongitudeDifference / LatitudeDifference)) AS DirectionInDegrees  

 	FROM CustomerCoordinates  

 )  

 SELECT  

 	CustomerID,  

 	CompanyName,  

 	DirectionInRadians,  

 	DirectionInDegrees  

 FROM DirectionCalculation  

 ORDER BY DirectionInDegrees;  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .WithCTETable(new Table("CustomerCoordinates"), new SqlQueryBuilder()  

         .Select()  

         .Columns("CustomerID", "CompanyName")  

         .Column(new ColumnArithmatic()  

             .StartBracket()  

                 .Value(47.6062).ADD()  

                     .StartBracket()  

                         .SqlFunction(new ROW_NUMBER().ORDER_BY(new OrderBy().SetSelectNull()))  

                     .EndBracket().MULTIPLY().Value(0.5)  

             .EndBracket().SUBTRACT().Value(47.6062)  

         , "LatitudeDifference")  

         .Column(new ColumnArithmatic()  

             .StartBracket()  

                 .Value(-122.3321).ADD()  

                 .StartBracket()  

                     .SqlFunction(new ROW_NUMBER().ORDER_BY(new OrderBy().SetSelectNull()))  

                 .EndBracket().MULTIPLY().Value(0.8)  

             .EndBracket().SUBTRACT().Value(-122.3321)  

         , "LongitudeDifference")  

         .From("Customers")  

     )  

     .WithCTETable(new Table("DirectionCalculation"), new SqlQueryBuilder()  

         .Select()  

         .Columns("CustomerID", "CompanyName", "LatitudeDifference", "LongitudeDifference")  

         .Column(new ATAN(new ColumnArithmatic().Column("LongitudeDifference").DIVIDE().Column("LatitudeDifference"))  

         , "DirectionInRadians")  

         .Column(new DEGREES(new ATAN(new ColumnArithmatic().Column("LongitudeDifference").DIVIDE().Column("LatitudeDifference")))  

         , "DirectionInDegrees")  

         .From("CustomerCoordinates")  

     )  

     .Select()  

     .Columns("CustomerID", "CompanyName", "DirectionInRadians", "DirectionInDegrees")  

     .From("DirectionCalculation")  

     .OrderBy(new OrderBy().Set(new Column("DirectionInDegrees")))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
WITH CustomerCoordinates
AS (SELECT CustomerID,
           CompanyName,
           (@pMAIN_2507192103022644500 + (ROW_NUMBER() OVER (ORDER BY (SELECT NULL))) * @pMAIN_2507192103022644501) - @pMAIN_2507192103022644502 AS LatitudeDifference,
           (@pMAIN_2507192103022644503 + (ROW_NUMBER() OVER (ORDER BY (SELECT NULL))) * @pMAIN_2507192103022644504) - @pMAIN_2507192103022644505 AS LongitudeDifference
    FROM Customers),
 DirectionCalculation
AS (SELECT CustomerID,
           CompanyName,
           LatitudeDifference,
           LongitudeDifference,
           ATAN(LongitudeDifference / LatitudeDifference) AS DirectionInRadians,
           DEGREES(ATAN(LongitudeDifference / LatitudeDifference)) AS DirectionInDegrees
    FROM CustomerCoordinates)
SELECT CustomerID,
       CompanyName,
       DirectionInRadians,
       DirectionInDegrees
FROM DirectionCalculation
ORDER BY DirectionInDegrees ASC;


            
        

Parameters (If used)

Query Results 1: