SELECT (CONVERT(int,CONVERT(char(8),@cal_dt,112)) - CONVERT(char(8),@birth_dt ,112)) / 10000
( Dateadd(year, Year(@price_dt) - Year(i.birth_dt), i.birth_dt) BETWEEN DATEADD(DAY,1,@last_price_dt) AND @price_dt
OR Dateadd(year, Year(@last_price_dt) - Year(i.birth_dt), i.birth_dt) BETWEEN DATEADD(DAY,1,@last_price_dt) AND @price_dt)
沒有留言:
張貼留言