I have a MS SQL Query that is pulling data via from a remote server.The data that I\'m pulling down needs to be filtered by a date that is determined at run time..When I run the query like this:
I\'ve been battling this one for a while now. I have a stored proc that takes in 3 parameters that are used to filter. If a specific value is passed in, I want to filter on that. If -1 is passed in, g
I have a table likes the below. idsession_idstart_timeanswer_time 11112022-12-06 13:40:502022-12-06 13:40:55
We are facing a performance issue while executing a stored procedure. It usually takes between 10-15 minutes to run, but sometimes it takes up to more than 30 minutes to execute.