Window functions are what every T-SQL programmer should know. Part 2.

December 9, 2018

Author - Dmitriy Fedyashov

In the second part of the article we will talk about the functions themselves, which are used to form values. The window function calculates the value from a set of data associated with the current row, that is, data from the same group, if Partition by is used. Conventional aggregate functions for ...

Window functions are what every T-SQL programmer should know. Part 1.

December 6, 2018

Author - Dmitriy Fedyashov

Long time ago an interesting functionality appeared in Microsoft SQL Server 2005- window functions. These functions allow you to perform calculations in a given range of lines within a Select clause. For those who have not encountered these functions, the question arises - “What does window me...

How to use stored procedures in FastReport.Net

August 14, 2018

Author - Dmitriy Fedyashov

In this article we will discuss the use of stored procedures to retrieve data for a report. Using the MS SQL example, I'll show you how to create and use functions in a report. As you know, Transact SQL allows us to create stored procedures and functions. Stored procedures are used to automate any ...

How to use dynamic queries in FastReport.Net

August 14, 2018

Author - Dmitriy Fedyashov

Most users of FastReport.Net build reports receiving data from SQL DBMS, and would like to take advantage of Sql in their reports. Nothing prevents you from using dynamic queries, stored procedures and functions. In this article, we will have a look at how to use dynamic queries when creating a repo...

How to use SQL functions in FastReport.Net

August 14, 2018

Author - Dmitriy Fedyashov

To obtain data in MS SQL, you can use sql queries, stored procedures, and stored functions. We have already discussed how to use dynamic queries and stored procedures as a report data source. In this article, we will create a table and scalar function and use them in the report. I recall that table...