36 docs tagged with "SQL Server"

SQL Server: Calculate Running Total or Cumulative Sum with Subquery

SQL Server: Transform date and time values into human-readable formats such as yyyy-MM-dd, yyyyMMddHHmmss, perfect for enhancing the user experience on your website or application

SQL Server: The AT TIME ZONE clause in T-SQL enables the conversion of UTC to the Local time zone while seamlessly accounting for Daylight Saving Time changes.

Discover various approaches in SQL Server to detect overlapping date ranges within tables using custom function and stored procedure. Enhance your database skills with practical insights on handling overlapping time periods.

Window Function is the Easiest and Fastest Way to Calculate Running Total in SQL Server

Download AdventureWorks database backup from Github, install, restore, and verify database connection. The process for setting up any version of the AdventureWorks database (e.g., AdventureWorks2019, AdventureWorks2022) is generally similar.

SQL Server: Calculate Running Total or Cumulative Sum with Self Join

This T-SQL solution efficiently expands date range into multiple individual rows using recursive Common Table Expressions (CTE). By employing this method, the process of breaking down date range into multiple distinct rows is streamlined, providing a more effective and manageable approach to handling date-related data within the context of a SQL database.

Both approaches serve the same purpose of expanding date ranges in SQL, but they have different characteristics and considerations.

Use Recursive CTE and LEFT JOIN techniques to easily find missing dates within a specified range. Finding missing dates is a crucial aspect in various data analysis scenarios

Use Recursive CTE and LEFT JOIN techniques to easily find missing values in sequence. Finding missing values in a sequence is crucial for maintaining data integrity, ensuring analytical accuracy, supporting informed decision-making, and contributing to the overall reliability and quality of data-driven systems.

T-SQL Learn how to efficiently transform time strings in the format HH:mm:ss into either the equivalent time data type, the total number of minutes, or the total number of seconds using SQL Server's T-SQL.

T-SQL Stored Procedure to Dynamically PIVOT Rows to Columns with Built-In PIVOT Operator.

Explore the performance differences between the HAVING and WHERE clauses by looking into the order in which filtering is applied.

In general, for smaller datasets or when you need a simple data structure, table variables can be a good choice. For larger datasets or when you need more advanced features like indexing and better statistics, temporary tables might be more appropriate.

Microsoft SQL Server TSQL Scripts: PIVOT Rows to Columns with Built-In PIVOT Operator or multiple CASE Statements

SQL techniques to group data by 5, 10, 15, 20, or 30 minute intervals. Round datetime up, round down, or round to nearest X minute interval.

In this article, We'll check and validate email addresses using the LIKE clause in combination with the built-in PATINDEX function.

SQL Server: UNPIVOT Columns to Rows with Built-In UNPIVOT Operator. Alternatively, Use UNION ALL Statements to UNPIVOT to Convert Columns to Rows.

SQL Server: UNPIVOT Columns to Rows with Built-In UNPIVOT Operator. Alternatively, Use UNION ALL Statements to UNPIVOT to Convert Columns to Rows.

Microsoft SQL Server TSQL Scripts: Numbers Generator like generate_series in PostgreSQL! Using Recursive CTE or Cross Join SQL techniques to generate a virtual numbers table for any range of number. Print 1 to 100. Print 1 to 1001.

With a magical LEFT JOIN, you can effortlessly capture all rows from your primary table and unlock valuable information from the secondary table, even if there are no direct matches.

With a magical RIGHT JOIN, you can effortlessly capture all rows from your primary table and unlock valuable information from the secondary table, even if there are no direct matches.

A cross join combines all rows from two or more tables, creating a Cartesian product that explores every possible combination of data.

Confused about INNER JOIN in SQL? Our practical example simplifies the syntax and demonstrates how this powerful operation can be used to merge datasets efficiently.

SQL Server: The FORMAT function provides a more flexible way to format datetime values in T-SQL.

Demonstrate Using SELF-JOIN Technique to Find and Check Overlapping Date Ranges in SQL: A User Subscription Scenario

SQL Server: Solving a sreal-world scenario using the UPDATE statement in combination with JOIN and WHERE clauses.

SQL Server: Leveraging the power of the MERGE statement's OUTPUT clause to effectively track and manage data modifications. Dive into real-world examples demonstrating how to capture and preserve altered data into a regular table, temporary table, or table variable, gaining valuable insights into the before and after states of your records.

SQL Server: Leveraging the power of the UPDATE statement's OUTPUT clause to effectively track and manage data modifications. Dive into real-world examples demonstrating how to capture and preserve altered data into a regular table, temporary table, or table variable, gaining valuable insights into the before and after states of your records.

SQL Server: Learn how to easily create a comma-separated list from multiple rows using the powerful STRING_AGG() function!

SQL Server: Learn how to utilize OPENJSON with CROSS APPLY to navigate through nested JSON structures. Explore practical examples showcasing OPENJSON's flexibility and effectiveness in dealing with arrays and nested JSON objects

SQL Server: When performing UPDATE with JOIN, using common table expression (CTE) can be very intuitive

SQL Server: When using table aliases in an UPDATE statement, you assign shorter and more convenient names to tables, which can make the statement easier to read and write.

SQL Server: Learn how to effectively use the ORDER BY CASE-WHEN statement to perform advanced multi-column sorting in your SQL queries.

Discover how FULL JOIN combines records from two tables, even with NULL values on both sides, ensuring no data is left behind!