Skip to content
Home ยป SQL Tutorials

SQL Tutorials

This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .

You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.

How to get multiple rows data in single row in SQL

This article demonstrates how to Convert multiple rows into a single comma separated row, it can be done by using in-built SQL functions. As you… Read More »How to get multiple rows data in single row in SQL

 8,294 total views,  28 views today

How to get the size of table in SQL

There are multiple ways to get the size of table in SQL Server. Lets take a look on them one by one. Using sp_spaceused system… Read More »How to get the size of table in SQL

 6,139 total views,  3 views today

Insert same rows multiple times in table

Sometimes you need to insert same row multiple times in a table. There are many ways to do that but here we will see one… Read More »Insert same rows multiple times in table

 6,837 total views,  4 views today

How to compare column names in two tables in SQL

In this article you will see how to compare column names in two table. Assume that, you have two tables and you are asked to… Read More »How to compare column names in two tables in SQL

 12,681 total views,  6 views today

Lost update problem in concurrent transations

A lost update problem occurs in concurrent transactions, when two transactions try to read and update the same column on the same row within a… Read More »Lost update problem in concurrent transations

 4,422 total views

Display a fixed number of rows per page in SSRS

This article demonstrate how to display a fixed number of rows per page in SSRS. Lets see step by step implementation of how to fix… Read More »Display a fixed number of rows per page in SSRS

 6,020 total views,  2 views today

Auto Refresh SSRS Report Data

This article demonstrate how to auto refresh SSRS report data, in SSRS report you can set auto refresh time interval (in seconds) for report, at… Read More »Auto Refresh SSRS Report Data

 5,526 total views,  2 views today

Create Multi Group Drill Down Report in SSRS

This article demonstrate how to create a multi group drill down report, means drill down report on nested grouping. Lets see the step by step… Read More »Create Multi Group Drill Down Report in SSRS

 2,975 total views,  2 views today

Create Drill Down Group report in SSRS

This article demonstrate how to create a Drill Down group report in SSRS. In general, a drill down report allows users to click on plus… Read More »Create Drill Down Group report in SSRS

 7,376 total views,  3 views today

Create an Embedded Data Source in SSRS

An Embedded data source, also known as a report-specific data source is a data connection that is saved in the report definition, and embedded data… Read More »Create an Embedded Data Source in SSRS

 2,451 total views,  1 views today

Add Row Number for grouped data

This article demonstrate how to add a row number for grouped data in SSRS report. Means separate the row counts based on grouping. Suppose for… Read More »Add Row Number for grouped data

 8,014 total views,  1 views today

Show No Data found message when no row returned in SSRS

This article demonstrate how to display a message when no row or data found for user selection in SSRS report. Lets see step by step… Read More »Show No Data found message when no row returned in SSRS

 11,665 total views,  4 views today

Alternate row colors in SSRS

This article demonstrate how to set alternate row background colors for SSRS table report. As you can see, here we have a sample report name… Read More »Alternate row colors in SSRS

 3,676 total views,  1 views today