Comments by KriShna RaJendra N PraSad

KriShna RaJendra N PraSad 21-Feb-22 6:33am View

No sir I am not changed any port. It was running successfully but suddenly stopped working. after multiple Hits.

KriShna RaJendra N PraSad 21-Feb-22 6:32am View

Sir I tried with different browsers still problem was same.

KriShna RaJendra N PraSad 9-Oct-20 11:24am View

Here i need to print the working day by skipping holidays and there is a service ID for 1 we have to calculate 30 days and for 2 calculate 5 days.

Application_No Service_TypeID School_update
202010090351001 1 2020-10-09 16:06:42.187
202010090552001 2 2020-10-09 17:49:54.037

KriShna RaJendra N PraSad 9-Oct-20 11:23am View

Holiday_list

Date_Fmt Holiday_Name
2020-10-02 Gandhi Jayanthi
2020-10-04 Sunday
2020-10-10 Second Saturday
2020-10-11 Sunday
2020-10-18 Sunday
2020-10-24 Fourth Saturday
2020-10-25 Sunday
2020-10-26 Vijayadashami
2020-10-30 Ed Milad
2020-10-31 Valmiki Jayanthi
2020-11-01 Sunday
2020-11-08 Sunday
2020-11-14 Second Saturday
2020-11-15 Sunday
2020-11-16 Balipadyami
2020-11-22 Sunday
2020-11-28 Fourth Saturday
2020-11-29 Sunday
2020-12-03 Kanakadasa Jayanthi
2020-12-06 Sunday
2020-12-12 Second Saturday
2020-12-13 Sunday
2020-12-20 Sunday
2020-12-25 Christmas
2020-12-26 Fourth Saturday
2020-12-27 Sunday

this is the one table and another is below

Application_Status

Application_No School_update
202010090351001 2020-10-09 16:06:42.187
202010090552001 2020-10-09 17:49:54.037

KriShna RaJendra N PraSad 9-Oct-20 11:20am View

sure

KriShna RaJendra N PraSad 9-Oct-20 11:08am View

Actually I tried in different way but no luck. My error is in the below query only.

select CONVERT(CHAR(10), dt+(select count(*) from Holiday_list where Date_Fmt between School_update and dt ),103) cnt from (select case when Service_TypeID='1' then (School_update + 30) else (School_update + 5) end as dt,School_update from Application_Status)a

Here Application_Status is sone table with Column name School_Update and Holiday_List is another table with column name Date_Fmt.

KriShna RaJendra N PraSad 9-Oct-20 1:47am View

https://stackoverflow.com/questions/4116596/converting-python-code-to-php

Hope this link will be help for you. Try once.

KriShna RaJendra N PraSad 9-Oct-20 1:45am View

https://www.monitis.com/blog/how-to-get-started-with-nosql/

KriShna RaJendra N PraSad 9-Oct-20 1:37am View

Thank you so much...

KriShna RaJendra N PraSad 8-Oct-20 7:51am View

Thank you so much Sir for your quick solution. one small help the start date is in another table the table name called as Application_Status and column name is School_update

KriShna RaJendra N PraSad 8-Oct-20 6:22am View

Thanks For your replay and solution.

Here this is the Government office so the holidays would be on all Sunday's, 2nd and 4th Saturday and some other fixed Holidays those are festivals. I have a table which contains all the holiday list including all Sunday, 2nd, 4th Saturday and Festival holidays. I tried below Query and I am getting one date but if that date is in holiday list then i need a date which is not in the holiday list.

select CONVERT(CHAR(10), dt+(select count(*) from Holiday_list where Date_Fmt between School_update and dt ),103) cnt from (
select case when Service_TypeID='1' then (School_update + 30) else (School_update + 5) end as dt,School_update from Application_Status)a

Thanks in Advance.

KriShna RaJendra N PraSad 8-Oct-20 5:58am View

Yes it should not move if the holiday is on 2020-10-13. It should give next working date. the date which is not in the holiday list. Thanks in advance.

Comments by KriShna RaJendra N PraSad (Top 12 by date)