Yes.. you are correct. we are going to integrate this SP with UI.. So want to optimise further .

okay.. i can put it my question like this.. how can i optimise my SP ?

Hi,

If you see SP , there are 4 IF conditions i used, they suggested me to use WHILE LOOP instead of multiple IF conditions. I am not able to Implement...

I Have tried. I didn't get businessdays and holidays (weekends also).

if possible would you dont mind please write query for me. i am beginner in SQL and i am...

Its my mistake. Year column is present in Table as well as view.

Can you help how to take business days and how to populate each day for month.

Help Appreciated.