asked
Calculated Columns
How would I add a column that would supply the number of days for the following? I originally had three separate stored procedures that returned the rows. I need to use just one for my chart. 1. DATEDIFF(DAY, GetDate(), DATEADD(day, (P.Planning_LeadTime * -1), PLO.Want_Date)) BETWEEN -10 AND -20 2. DATEDIFF(DAY, GetDate(), DATEADD(day, (P.Planning_LeadTime * -1), PLO.Want_Date)) > -20 3. DATEDIFF(DAY, GetDate(), DATEADD(day, (P.Planning_LeadTime * -1), PLO.Want_Date)) < -20
The code snippets above are predicates (they equate to either true or false) - what do you use the values of these to do?
Why not use a view?
The view is simply a query over a table (or set of tables), so it would look like: select a, b, a+b as CalculatedColumn from Table
9 People are following this question.
