This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
The code you have posted is incorrect. The query has two variables, @start_tradedate and @end_tradedate, but no such variables have been declared. On the other hand, you have two parameters @startDate and @endDate which are not used.
apologies, I forgot to paste those variables correctly. Other than that is all ok do you think? Thanks
So you are asking why code you don't show us is not working?
Well, beside the variable-name mismatch, the code appears to match the description, but I don't know your data, how you call the procedure. Or for that matter what code you are actually running...
Apologies. 1- It seems that I am unable to paste the stored proc and so I took an image of the sample stored proc. 2- Thank you for your help