Search

SSRS - Multiple ways to split a string into multiple lines

SSRS - Multi Font Color / Multi Font Size within Single Field / Textbox

SSIS - Move Folder from one Drive to Another Drive Using File System Task

SSIS - How to Add Missing Control Flow Items / Data Flow Items to the SSIS Toolbox

SQL Server - Split delimited string into separate columns

Generate XML with Same Node Names using FOR XML PATH

T-SQL: Remove Leading and Trailing Zeros

Avoid T (space) while generating XML using FOR XML clause

Generate XML - Column names as tag name with column values as text() enclosed within their column name tag

SQL Server - Import/Shred XML from XML file placed in a folder into table

If the requirement is to import/shred XML from XML file placed in a folder into table , then this can be done by creating stored procedure using XQUERY & OPENROWSET :

Refer my post on Technet gallery  - http://gallery.technet.microsoft.com/scriptcenter/SQL-Server-ImportShred-XML-7f3baa40#content