
01-06-11, 23:40
|
|
Registered User
|
|
Join Date: Jul 2010
Location: ISHHHH
Posts: 130
|
|
Quote:
Originally Posted by Marcel Crudele
=======================================
How to calculate age in 2 easy steps…
=======================================
1. Run the following script in any SQL 2005 DB you want to determine Age in.
2. Calculate age anytime you want by sending a start date and end date in the format
select dbo.CalcAge(@StartDate, @EndDate)
-- ================
-- END SCRIPT
-- ================
--Marcel Crudele
--innerEcho, Inc.
|
nice one  
__________________
WiTh Tnks & ReGaRdS
mAtHuKuMaLi
|
|