Results for "Any"
12 / 184 posts
How to one series with comma separate(any Delimiter) value split into in rows
If we have one series with comma separate(any Delimiter) value and we want split into in rows, I have create function for that: IF OBJECT_ID('TF_SplitSerie…
How to Two series with comma separate(any Delimiter) value split into in rows respectively
If we have two series with comma separate(any Delimiter) value and we want split into in rows, I have create function for that: IF OBJECT_ID('TF_SplitTwoSe…
Window Aggregate Functions in SQL
What is window function: Imagine you have a dataset with many rows, and you want to perform some calculations on each row based on a group of rows related …
ANY and ALL operators used in SQL
The ANY operator: returns a boolean value as a result returns TRUE if any of the sub-query values meet the condition Any means that the condition will be t…
Advance functions in Power BI
ALL Filter: The ALL filter returns all the rows in a table or all the values in a column, ignoring any filters that might have been applied. This function …
What is Data Lake
A data lake is a centralized repository that allows you to store all your structured and unstructured data at any scale. You can store your data as-is, wit…
Data Import from text/CSV file in SQL Server
Step-by-Step Explanation 1. Checking and Dropping Existing Temporary Tables Before creating the temporary tables, the script ensures that any previously ex…
Understanding Default Size of VARCHAR in SQL Server
Introduction When working with SQL Server, developers often use the VARCHAR data type to store variable-length character data. However, many overlook a cri…
SQL Logical Operators with Examples
SQL logical operators are used to filter data by combining multiple conditions in SQL queries. These operators help in refining queries to fetch specific r…
concat() and concat_ws() in PySpark
In PySpark, both concat() and concat_ws() are used to combine multiple columns into a single string column. ✅ concat() – Combines columns without any delim…
Azure Data Factory (ADF)
Azure Data Factory (ADF) Kya Hai? Soch le tu ek delivery company chalata hai – jaise Swiggy/Zomato. Restaurant se khana uthaya → pack kiya → raste me check…
SQL Server Multi-Level Approval Workflow with Auto Skip Logic
In many enterprise applications like HRMS, Travel Requests, Expense Approval, Purchase Approval , we need a multi-level approval workflow . But real system…