how to get difference between two dates in sql server from two different columns and then also store the difference in another column..
lets say .. column 1 has date 1,
column 2 has date 2,
now sql find their differnce i:e , (date2 - date 1) and store the difference in column 3 ..
how can i do this ?