Lamak questions

Lamak answers

• Find duplicates, display each result in sql
• use sql selected values as row names for another select
• Pivot SQL query - Show Date in column
• Tilde (~) Delimited File Read in SSIS
• Join based on the value to different table
• How to use TO_CHAR function functionality in SQL Server 2008
• Using Case Statement in Where Clause (with column)
• Rotate SQL Table
• SQL Query Statement Structure
• Dynamic SQL query string truncated to 256 characters