Hi

use Distinct:

SELECT DISTINCT d.personname, d.[datetime], d.sys_nr, d.door_nr, r.[Door Reader]

FROM [DATEBOOK] d

INNER JOIN [READERS] r

ON r.sys_nr = d.sys_nr

AND r.door_nr = d.door_nr

OR

GROUP BY:

SELECT d.personname, d.[datetime], d.sys_nr, d.door_nr,...

Thanx very much John

for help me very fast

your solution working very good

Saludos

i work company for a company

OK, Remi

Thanks

hi Remi

this a error message

FAILED: select

c.tiponegocio,dp.cveprocto,sum(dp.cajas) cajas

from prvDetallePedido dp

inner join (select cvecliente,case when cvetiponegcontrolado >= 503 and cvetiponegcontrolado <= 509

or cvetiponegcontrolado = 516 then 1 else 0...

Hi

probe this

WHERE tblAssets.SerialNumber LIKE '%' + @VALUE + '%'

 AND  tblSites.ID =(SELECT tblUsers_Sites.ID FROM tblUsers_Sites WHERE UserID = @userid)

thanks Nilssond

your solution is perfect and easy

hello jose

i was have a similar problem

i follow the next step for solve this problem

1. put my db in single user

2. first run DBCC CHECKDB (databasename, repair_allow_data_loss)

3. after run DBCC...