Database

i.j.russell wrote:

Has it only just started happening as you say that the code is 5 years old?

i.j.russell wrote:

Does it always cause a PK violation?

i.j.russell wrote:

Are you only inserting into 1 table?

i.j.russell wrote:

Are all of the datetime values obtained from the same source?

i.j.russell wrote:

Is the datetime value different for each insert?

create table MyTable
(
   MyCol  datetime
      PRIMARY KEY CLUSTERED
)

Employer
--------
IdEmployer
Name

CustomerEmployer
----------------
IdEmployer
IdCustomer

Customer
--------
IdCustomer
{other columns}

papa80 wrote:

SO my question is please give me query who give it to me employer.name with max customet how to do that???

SELECT Employer.Name
FROM Employer
INNER JOIN CustomerEmployer ON CustomerEmployer.IdEmployer = Employer.IdEmployer
WHERE IdCustomer = (SELECT MAX(IdCustomer) FROM CustomerEmployer)

SELECT Employer.Name, CustomerCount.NumCustomers
FROM Employer
INNER JOIN (SELECT IdEmployer, COUNT(*) AS NumCustomers
            FROM CustomerEmployer) AS CustomerCount
ON CustomerCount.IdEmployer = Employer.IdEmployer

Colin Angus Mackay wrote:

SELECT Employer.Name, CustomerCount.NumCustomersFROM EmployerINNER JOIN (SELECT IdEmployer, COUNT(*) AS NumCustomers FROM CustomerEmployer) AS CustomerCountON CustomerCount.IdEmployer = Employer.IdEmployer