sharad purnima 2020

Comments

Post a Comment

Popular posts from this blog

IIS not work, Give error "HRESULT...." or When IIS start gives error "Already running a process on this port"

Hello All, In my pc, IIS was working fine as I know. Today when I want to run my site from IIS. It gives me above error . I am searching lot for my this issue. Even I was did stop my firewall , still getting the same. So I googling and get solution that skype is also share the same port of IIS : 80. So follow below to solve this issue. The cmd NETSTAT -ano showed Skype (via the PID) was using port 80. This was preventing IIS starting a local website with the message: The process cannot access the file because it is being used by another process. (Exception from HRESULT: 0x80070020) This was resolved in Skype by unchecking T ools > Options... > Advanced > Connection > "Use port 80 and 443 as alternatives for incoming connections" Refer link :Prevent Skype using port 80 and causing IIS to throw a HRESULT: 0x80070020 Exception
Read more

How do I compare all the column values based on the Partition by with ID

I have a case where there are many rows for the same ID, I just wanted to know if there is any way to find out whether the given ID includes some specific value or not. Table 1 ID Dept Salary Flag Date 1 IT 5000 N 2017-01-01 1 IT 5000 N 2017-01-02 1 IT 5000 N 2017-01-03 1 IT 5000 N 2017-01-04 1 IT 5000 N 2017-01-05 2 HR 4000 N 2017-01-01 2 HR 4000 N 2017-01-02 2 HR 4000 Y 2017-01-03 2 HR 4000 N 2017-01-04 2 HR 4000 N 2017-01-05 3 Fin 4500 N 2017-01-08 3 Fin 4500 N 2017-01-09 3 Fin 4500 N 2017-01-10 3 Fin 4500 N 2017-01-11 3 Fin 4500 ...
Read more
 Today is the auspicious day for me as I buying a new home from almost last year. And now the dream come true. Today DD of home loan 27lk will be generated from SBI(Parasbhai) and probably in next month we will get the possession.  House address as G-1003, Ashray-10, Nr. Khodiyar temple, New Ranip, Ahmedabad - 382480 My first step I taken on last year on 24-Oct-2019 via Sureshbhai , Hasmukhlal Patel and Amit Mandal In janurary, expeced that we will get the house, so I aggree and taken the sanction letter from SBI. But the time was gone and in mid the Corona virus comes in March 22 2020 and lock down start. Wife and children were at Bikaner and coming on 1st April 2020 and they fuss gaye.
Read more