podiluska questions

podiluska answers

• Best method to split columns into rows?
• SQL Server stored procedure need to declare scalar variable
• SQL Server - find values in a range
• Manipulate results to display rows as columns
• Unpivot table with multiple columns and dynamic column names
• Efficient Date Comparisons in SQL
• Next/previous record based on current
• SQL query to find out of order records
• WHERE with CASE and null checking
• using tsql to create a contigious time line set