To proceed with this check execute the following queries according to your database type:
- Access database:
Select * from
[GLAccount]
where
[Number] in
(Select
[Number]
from
[GLAccount] Group
by
[Number] having count(*)
>
>1)
order
by
[Number], [Id]
- SQL Server database:
Select * from
[GLAccount]
where
convert(varchar, [DBId])
+ '-' + [Number] in
(Select
convert(varchar, [DBId])
+ '-' + [Number]
from [GLAccount]
Group by convert(varchar, [DBId]) + '-' + [Number] having count(*) > 1)
order by [DBId], [Number], [Id]