E
EManning
Using A2K. Just curious if I can do this...I've got a number of stored
procedures that take a year range as input parameter. The year range may
come in as '2003-2004' or '2004-2005' and so on. The data being queried has
a beginning date and ending date field, both datetime and stored as
mm/dd/yy. I only want the data whose beginning date is within the year
range. Is there a way to call a function to determine if the beginning date
falls within this year range without having to code this into each and every
stored procedure?
Thanks for any help or advice.
procedures that take a year range as input parameter. The year range may
come in as '2003-2004' or '2004-2005' and so on. The data being queried has
a beginning date and ending date field, both datetime and stored as
mm/dd/yy. I only want the data whose beginning date is within the year
range. Is there a way to call a function to determine if the beginning date
falls within this year range without having to code this into each and every
stored procedure?
Thanks for any help or advice.