Jul
24
accepted Does SQL Server Date Correlation Optimization only work on DateTime fields, or will a Date work, too?
Jul
24
awarded  Yearling
Jul
24
asked Does SQL Server Date Correlation Optimization only work on DateTime fields, or will a Date work, too?
Feb
12
accepted Why can you only drop a SQL Server view in the current database?
Jan
22
awarded  Nice Question
Jan
17
asked Why can you only drop a SQL Server view in the current database?
2018
Nov
16
awarded  Popular Question
Jan
16
accepted Is there an efficient way to match multiples headers that have the same set of details?
Jan
16
answered Is there an efficient way to match multiples headers that have the same set of details?
Jan
9
revised Is there an efficient way to match multiples headers that have the same set of details?
Adding business context to help focus answers.
Jan
9
comment Is there an efficient way to match multiples headers that have the same set of details?
Ah - thank you for giving it a name - very hard to google this. So - before I dive in to research - is my approach reasonable?
Jan
9
asked Is there an efficient way to match multiples headers that have the same set of details?
2017
Aug
7
comment Why does SQL try to convert rows that are excluded by my where clause?
Lot of good responses, but I'll mark yours as the answer because I think it's the most detailed explanation.
Aug
7
accepted Why does SQL try to convert rows that are excluded by my where clause?
Aug
7
revised Why does SQL try to convert rows that are excluded by my where clause?
Fixed fiddle
Aug
5
awarded  Curious
Aug
4
answered Why does SQL try to convert rows that are excluded by my where clause?
Aug
4
comment Why does SQL try to convert rows that are excluded by my where clause?
Hi @Evan, you are absolutely right - my fault for messing up the scaffolding code. The problem is, I want to be able to select from the view without quotes around the number, because I know the values from the set will all be numeric based on the where clause.
Aug
4
revised Why does SQL try to convert rows that are excluded by my where clause?
error in sql fiddle explanation
Aug
4
asked Why does SQL try to convert rows that are excluded by my where clause?