But I have predefined table tbl_holidays. I do not want to insert data in that.

Please note that if Jan 01 to Jan 10 is holiday defined in table. Then

I...

My requirement is not to excute exe. I just want to do something if it's holiday and something else if it's not.

i am looking for exact query. pls give me...