TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Basit Khan
NA
336
122.7k
FromDate & ToDate to be Changed after 14 Days.
Dec 17 2015 12:06 AM
Dear I have table called Mst_Crew.
Fields are
Cr_No numeric
Cr_Name varchar
FromDate date
ToDate date
I need to change the FromDate & ToDate when the ToDate pass the currentdate then need to be add 14Days on FromDate
For Example
CrNo CrewName FromDate ToDate
1 A 29-Nov-15 13-Dec-15
2 B 06-Dec-15 20-Dec-15
3 C 13-Dec-15 27-Dec-15
4 D 22-Nov-15 06-Dec-15
The Next Change will be
CrNo CrewName FromDate ToDate
1 A 27-Dec-15 10-Jan-16
2 B 03-Jan-16 17-Jan-16
3 C 10-Jan-16 24-Jan-16
4 D 20-Dec-15 03-Jan-16
It means that.
When Todate<GetDate() then in FromDate Column ToDate+14 and in ToDate Column FromDate+14
How to do this in SQL
Thanks
Basit.
Reply
Answers (
1
)
job scheduling in sql
How to insert table data based on other table id