Being extensively involved in report development projects, I’ve come across numerous occasions where requirements asks for the ability to implementing a logic to filter data in stored procedures based on multiple selection parameter value. In these cases the values will…
T-SQL tips: Pattern Search and Replace within XML using Xpath Functions
T-SQL provides good support for generating and manipulating XML data from SQL 2005 onwards. Using the functions like query(), nodes() etc we can shred the data within XML document. Similarly to build a XML out of relational data we can…