I am having a 7 + years of experience in microsoft technologies including Asp .NET, C# Power BI, SQL Server, SSRS, SSIS, Azure Fundamentals, & Python.
This article demonstrate how to load multiples .txt or .csv files to a SQL Server table. As you can see here we have two flat… Read More »Load Multiple .text or .csv files to table in SSIS
1,605 total views, 29 views today
To find the highest salary of employee in each department, first we will create a sample tables named EmployeeDetails and Department as shown below. CREATE… Read More »How to get top salary of each department
1,957 total views, 15 views today
HTML Color picker, you can search colors either by color name or color hexacode 792 total views, 3 views today
792 total views, 3 views today
In this article you will see how to change the background color for specific rows in a matrix based on values in column. Here, we… Read More »Change matrix background color based on value
1,200 total views, 5 views today
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,126 total views, 26 views today
You may have faced a situation where you are asked to find values in a column with leading or trailing spaces or remove the leading… Read More »How to find leading and trailing spaces in SQL Server ?
1,422 total views, 8 views today