I have a SELECT statement, it is calculating the same DateDiff about 5 times. I'm using some CASE WHEN stuff and the result of DateDiff in days is how I determine what part of the case it goes with.
Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results