1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| SELECT Customerkey AS RefKey,
CompanyName AS RefName,
MotherCompanyKey AS RefParentKey
FROM dimCustomer
WHERE CONTAINS(CompanyName, @CustomerString)
OR CONTAINS(MotherCompanyName, @CustomerString)
OR (CustomerKey IN
(SELECT MotherCompanyKey
FROM dimCustomer
WHERE CONTAINS(CompanyName, @CustomerString)
AND MotherCompanyKey != 0))
AND InactiveFlag <> 0
ORDER BY CASE MotherCompanyKey
WHEN 0 THEN CompanyName+convert(varchar, Customerkey)
ELSE MotherCompanyName+convert(varchar, MotherCompanyKey) + CompanyName
END |
