11
I am getting a date parameter value as '4-1-2009' from front end. Now I want to make it as
'4-1-2010' in my stored procedure. I am trying like below.
ALTER PROCEDURE [dbo].[SP_EMP]
@STARTDATE DATETIME,
@ENDDATE DATETIME,
@STARTDATE2 DATETIME,
SET @STARTDATE2=DATEADD(yy, 1, @STARTDATE)
AS
BEGIN
SELECT EMPNAME FROM EMP WHERE JOINDATE>@STARTDATE2
----// SOME JOINS //----
END
How can I do this? Please tell me.
Regards, N.SRIRAM