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
Ajay Mavatkar
NA
68
12.4k
NOT IN operator in sp for date field
May 17 2017 1:51 AM
How to use NOT IN operator in sp for a date field.
I need to delete some dates through a delete query inside sp.
DELETE FROM table1WHERE
[Date] NOT IN (@someDates)
@someDates is a parameter which holds date like this '05-29-2017' , '07-04-2017' , '09-04-2017'
It is giving error as follows
Conversion failed when converting date and/or time from character string
Please suggest
Reply
Answers (
3
)
Need to "loop" these codes until all records be deleted...
How do I display thumbnail of pdf and doc file which I have