Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
how to cal a datetime colum with int values
Prasad Bhagat
Jun 23 2015 6:19 AM
527
Reply
Dear all,
i have a procedure like bellow,
CREATE PROC USP_ABC
@month int,
@year int ,
as
begin
select * from tbl
where
(@month=0 or (SELECT DATEPART(MM, DOJ) FROM dbo.tbl_param_employee_master as month)= @month)and
(@year=0 or (SELECT DATEPART(yy, DOJ) FROM dbo.tbl_param_employee_master as year)= @year)
END
DOJ Date.
here DOJ datatype is date
so please suggest me how to call this query
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Select dates between two dates using isnull function
for creation fof database