A little tip how to format repeating values in SQL output using LAG function
IntroductionWhen and how to use sql formatting functions to format datetime values when it is being used by the application that is target to be run
Logical functions provide a way to use logical conditions to display one of several values. You can use logical functions to test a field’s value such as gender (M or F) and display another value(‘Male’ or ‘Female’) as a result. In...
Write a sql query in which we use only one IsNull() function and it will remove all Null values(if any) from entire result set(from all rows)
Executing a web service in a CLR based Table Valued Function resolving the problems faced during its execution and finally representing the IEnumerable output as a table in SQL Server.