Jayvee questions

Jayvee answers

• SSIS - Getting latest record of rows
• Technique for fixing XML parsing: illegal qualified name character
• Converting a bit to an int returns a negative value
• Import Excel (.xlsx) with SSIS and Excel source with worksheet containing multiple subsections
• Selecting columns as XML with namespace
• SQL Server Decimal precision
• SQL select items that make datetime range between flag toggle
• Coverting unicode string to non unicode string in SSIS 2012
• How Stuff Works Or Logic of Stuff & XML Path in SQL
• Component OLE DB source has no input