#DateForumTypeThreadPost
230 Apr 2008 @ 04:20 PDTDatabaseReplyTenure in years and months between two dateshope this helpsselect year('2008-04-30') - YEAR('2000-01-01') as years , month('2008-04-30')-MONTH('2000-01-01') as monthsThanks
130 Apr 2008 @ 12:32 PDTDatabaseTopicHow to Pass Database Name & Table Name as Input Parameter to Stored ProcedureHi Guys,I have a requirement where I need to pass the Database Name & Table Name as input parameter to the Stored ProcedureIs this possible...Query look like thisreplace PROCEDURE ISMAIMH.GET_ITEM_...