Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by dmacasaet
-
Stored Procedure to get Years,Months,Days bet 2 dates
this is excellent excellent james ...other users in this group will find this very useful...again thanks- dmacasaet
- Post #9
- Forum: Microsoft SQL Server: Programming
-
Stored Procedure to get Years,Months,Days bet 2 dates
I am actually a cold fusion programmer and rewrote this code from coldfusion (where it works perfectly)... Is there a way I can get my desired results in Transact-SQL? Any help will be very appreciated. Thanks Thanks again SQLBill :)- dmacasaet
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Stored Procedure to get Years,Months,Days bet 2 dates
Thank you SQLBill I get the values Years= 1 , Months= -11 and Days= -30 ...- dmacasaet
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Stored Procedure to get Years,Months,Days bet 2 dates
I am trying to get the results of three integer values corresponding to "number of Years" "number of Months" "number of Days" between two inputted dates... The code below does not error out but the computed values come out wrong...The expected results should have...- dmacasaet
- Thread
- Replies: 13
- Forum: Microsoft SQL Server: Programming
