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.
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
2,579 total views, 13 views today
Assume that, you have two tables and you are asked to find out the columns which exists in both table with same name or column… Read More »How to compare column names in two tables in SQL
4,127 total views, 27 views today
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
2,265 total views, 8 views today
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
3,404 total views, 9 views today
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
1,494 total views, 6 views today
Sometimes you need to export data from SQL Server tables, views or the result of any T-SQL query into excel file, reason could be anything… Read More »Export data from SQL Server to an Excel file
1,627 total views, 6 views today