Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
NOT IN operator in sp for date field
Ajay Mavatkar
May 17 2017 1:51 AM
215
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Need to "loop" these codes until all records be deleted...
the difference between ADO.NET and Entity Framework