Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
Select dates between two dates using isnull function
Prasad Bhagat
Jun 23 2015 2:53 AM
524
Reply
Dear All,
i have procedure like bellow
create proc usp_abc
@fromdate datetime,
@todate datetime
as
begin
select * from tbl
whete
(CONVERT(datetime,(select exit_status_Date from dbo.tbl_param_employee_exit_track where employee_d=tbl_param_employee_master.ID),103) between @fromdate and @todate)
i want to fetch all records between two dates if dates are null also
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
How to Add Column at Specific Location in Table in SQL
how to cal a datetime colum with int values