Hi, eID have only unique values but ID may have duplicate values

The server principal "DB1" is not able to access the database "DB2" under the current security context.

Thanks all

Thanks Luis. But each id has 1000 records with different date. How can i calculate count for range of date.