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 1ID Dept Salary Flag Date
1 IT 5000 N 2017-01-011 IT 5000 N 2017-01-021 IT 5000 N 2017-01-031 IT 5000 N 2017-01-041 IT 5000 N 2017-01-052 HR 4000 N 2017-01-012 HR 4000 N 2017-01-022 HR 4000 Y 2017-01-032 HR 4000 N 2017-01-042 HR 4000 N 2017-01-053 Fin 4500 N 2017-01-083 Fin 4500 N 2017-01-093 Fin 4500 N 2017-01-103 Fin 4500 N 2017-01-113 Fin 4500 N 2017-01-124 Edu 4800 N…
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 Tools > Options... > Advanced > Connection > "Use port 80 and 443 as alternatives for incoming connections"