32 lines
754 B
Transact-SQL
32 lines
754 B
Transact-SQL
SELECT TOP 100
|
|
a.Address_GUID
|
|
, a.ad_name
|
|
, a.AD_creation_OU
|
|
, a.AD_update_OU
|
|
,a.*
|
|
FROM dbo.Address a
|
|
WHERE 1=1
|
|
AND EXISTS(
|
|
SELECT 1
|
|
FROM [dbo].[Organizational_unit] ou
|
|
JOIN [dbo].[Address_OU_link] l ON l.AOUL_OU = ou.Organizational_unit_GUID
|
|
WHERE ou.OU_code='705'
|
|
AND l.AOUL_address = a.Address_GUID
|
|
)
|
|
--AND ou.OU_code='705'
|
|
--AND a.Address_GUID='9B30783A-FDD8-4B77-9B79-D5E70E327F56'
|
|
ORDER BY a.AD_name
|
|
|
|
|
|
RETURN
|
|
|
|
SELECT
|
|
a.AD_creation_OU
|
|
,*
|
|
FROM dbo.Address a
|
|
JOIN [dbo].[Address_OU_link] l ON l.AOUL_address = a.Address_GUID
|
|
WHERE l.AOUL_address='9B261B2E-6227-4540-BC42-9C509D219AD8'
|
|
|
|
SELECT *
|
|
FROM dbo.Organizational_unit
|
|
WHERE Organizational_unit_GUID='BD710DD2-DC90-4DF0-91E6-84DBE5572469' |