Varchar date columns. We do BI off a widely-used call center workforce scheduling system, where dates are commonly stored as varchar. Had an ETL failure this week -...
We've been using this method to do impact analysis, searching for specific text in RS dataset queries. Our little world started in SQL Server 2000, then 2005, now 2008R2. We...