|
Posted by Jules on 01/29/08 14:35
In my select statement, I return a column for 'datediff' using a CASE
query. I call this column 'Elapsed_days'
is there anyway I can use this result later on in the same select? IE
I want to refer to 'elasped days' in another CASE query rather than
have to re-write something which incorporates the original one.
Simpler the better - I'm new!
Make any sense?
Hope so
Navigation:
[Reply to this message]
|