Generating Nested XML Structures with FOR XML PATH

This blog gives you some insight on how nested XML structures can be easily built using FOR XML PATH constructConsider the illustration given belowcreate table parent_child(ParentID varchar(50),ChildID varchar(50))insert parent_childvalues (‘Parent1′,’Child1’),(‘Parent1′,’Child2’),(‘Parent1′,’Child3’),(‘Parent4′,’Child4’),(‘Parent5′,’Child5’)The requirement was to built a xml structure as below The…

How to solve Microsoft.ACE.OLEDB.12.0 error “Unspecified error”

The reason for writing this blog is for the last 2 hours I’ve been battling with the below error message OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)” returned message “Unspecified error”. Msg 7303, Level 16, State 1, Line 1…

Implementing Multivalued Parameter Filtering Using Logical Operators

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…