In SQL Server (Transact-SQL), the STUFF() function deletes a sequence of characters from a source string and then inserts another sequence of characters into the source string, starting at a specified position. Syntax The syntax for the STUFF function in Read More …
Category: Built-in Functions
Window Function In SQL Server
Introduction to Window functions Window functions operate on a set of rows and return a single aggregated value for each row. The term Window describes the set of rows in the database on which the function will operate. Window (or Read More …
How to select minimum value from group in a table
Sometimes, you need to define window frame within the table on the basis of certain criteria, to pick up some specific data. Today, I was developing one report for my customer and the requirement was very simple, to find the Read More …