Here's a simple SQL statement that I've used to help me resolve some of our issues be it customer, vendor or item master files:
Select custnmbr, Count(ADRSCODE) As AddressCount
From RM00102
Group By custnmbr
Having Count(ADRSCODE) > 1
or if you want detail use this
Select *
From RM00102
Inner Join (
Select CUSTNMBR, Count(ADRSCODE) As AddressCount
From RM00102
Group By CUSTNMBR
Having Count(ADRSCODE) > 1
) As A
On RM00102.CUSTNMBR = A.CUSTNMBR
This blog was created to help Program leads, solution architects and administrators of different enterprise solutions including ERP, CRM, SCM, WMS, PLM, Business Intelligence and many more.
Saturday, October 10, 2009
Subscribe to:
Posts (Atom)
e-Commerce discount types
In the world of retail today every retailer is trying to find ways and be creative to attract online customers. To attract your attention an...
-
The first time that you log in to Microsoft Dynamics GP 9.0, you can select to have default information that is specific to your job display...
-
I've filled out the survey and chose the functionalities I think would benefit a lot of industries. Below is a summary of the survey I s...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...