James Z questions

James Z answers

• Using if else block in pivot query
• Sorting in SQL query in ascending order
• SQL Server : ISNULL(compound NULL condition, 'a string') returns only the 1st character, under certain circumstance(s)
• SQL random name generator not inserting first and last name in the same row
• How to calculate time difference in T-SQL
• Need 8 characters form a lengthy RegKey path - Invalid length parameter passed to the LEFT or SUBSTRING
• SQL - Removing Duplicate Rows but Keeping Null Rows
• Loop through range of dates in SQL Server
• Split row based on start end date SQL Server
• How to write using BCP to a remote SQL Server?