Jayvee questions

Jayvee answers

• 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
• SQL Query to select records for rows having value =0 in one column and unique id in another column [closed]