Check your data via SQL

[Blog bot]

Источник: 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 PURCHTABLEgroup by DATAAREAIDhaving count(RECID) > 1




Источник: http://alexvoy.blogspot.com/2024/01/...a-via-sql.html