Excel Sort Function
The new Excel SORT function is one of the new dynamic arrays that are available in Microsoft 365. […]
function
Excel SUMPRODUCT Function
Below is an example of the SUMPRODUCT function. SUMPRODUCT multiplies corresponding cells from multiple arrays and returns the […]
Excel VBA Procedures
A procedure is a series of VBA statements that resides in a VBA module. A module can hold […]
C# Anonymous Functions
What are anonymoys functions? First of all, there is a page at Microsoft Docs that discusses Anonymous Functions […]
SQL Server Aggregate Window Functions Raptors
This post is another example of aggregate window functions. This time we are going to use some Toronto […]
SQL Server Aggregate Window Functions
Aggregate window functions in SQL Server are similar to grouped functions (SUM, AVG and so on) except that […]
SQL Server Functions
This post describes how you can create a user-defined function in SQL Server. We will start off with […]
SQL Server Datetime
The topic of date and time in SQL Server requires more attention than any of the other data […]
SQL Server Date Conversion Function
Here we have a couple of code examples that work with dates. The first one gets today’s date […]
SQL Server User-Defined Functions
In SQL Server, user-defined functions (UDFs) are similar to stored procedures, except that they do not support OUTPUT […]
C# Functions Part 6 Delegates
A delegate is a type that enables you to store references to functions. Delegates are important parts of […]
C# Functions Part 4 Out Parameter
You can pass values by reference. Also you can specify that a given parameter is an out parameter […]