Smita GudaleParent And Child DAX Functions In PowerBIThe following DAX functions are used for the manages data in the form of the parent-child relationship.Feb 3, 2020Feb 3, 2020
Smita GudaleExpression and TextBox in SQL Server Reporting Services(SSRS)The expression is a formula in SSRS that begins with an equal sign (=). Expressions are used in built-in functions, custom code, report…Jan 29, 2020Jan 29, 2020
Smita Gudale“Relational Algebra in Database”Relational algebra is a procedural query language.Jan 29, 2020Jan 29, 2020
Smita GudaleSQL Server AgentSQL server agent is a software that is provided by the SQL server. Which helps to run any SQL job as a background process.Jan 28, 2020Jan 28, 2020
Smita Gudale“Creating Report By Using SQL Server Reporting Services (SSRS)”SSRS is basically used for data displayed out to the end-user. SSRS is a reporting service that fetches the data from the SSAS as well as…Jan 28, 2020Jan 28, 2020
Smita Gudale“Common Table Expression(CTE) in SQL Server”Common Table Expression(CTE) in SQL Server defines a temporary result set that you can reference within another SELECT, INSERT, UPDATE…Jan 27, 2020Jan 27, 2020
Smita Gudale“SQL Queries For Finding Shortest and Longest String And Finding Vowels in The String”Query the two NAMES in DISTINCT TABLE with the shortest and longest NAMES, as well as their respective lengths (i.e.: number of characters…Jan 22, 2020Jan 22, 2020
Smita Gudale“SQL QUERIES INTERVIEW Q & A”In this article, let's have a look at complex queries in SQL. In the following EmpDetails table and EmpSalary table original data is…Jan 21, 2020Jan 21, 2020
Smita Gudale“Local Temp Table and Global Temp Table in SQL Server”LOCAL TEMP TABLE-Jan 14, 2020Jan 14, 2020