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…