mansi questions

mansi answers

• Remove duplicate rows from joined table
• query to remove first value from " For XML PATH "
• How to get file extension of file as a result of sql query?
• Add a Column that Represents a Concatenation of Two Other Varchar Columns
• Index Seek vs Index Scan in SQL Server [closed]