Источник:
http://alexvoy.blogspot.com/2024/01/...a-via-sql.html
==============
Sometimes we need to check or validate some data in a dev box. The fastest way to do that is to run a query directly in MS SQL management studio.
For example, I have hundreds legal entities and want to know in which of them I have some Purchase orders. Voila:
selectdataareaid
as Company,
count(RECID)
as 'Number of PO'
from PURCHTABLE
group by DATAAREAID
having count(RECID)
> 1
Источник:
http://alexvoy.blogspot.com/2024/01/...a-via-sql.html