I have a existing stored procedure that is running for front end application but the functionality of stored procedure is not working well. It is creating duplicate recocrds when the user enters or update any data. That should not happen.
Right now in the filter we are using datediff function in comparison to last modified date to get date with less than operator of some value. If the value is more sec then more duplicates if the value is less then no duplicates or some. So here we need to get rid of date difference and use an alternative or create a new stored proc to get same functionality.