brycecaruthers
2/8/2017 - 9:21 PM

find accounts by xxml share type for crm-specific (DS, eLead, Vin, Reynolds & Reynolds/ReyRey, etc.)

find accounts by xxml share type for crm-specific (DS, eLead, Vin, Reynolds & Reynolds/ReyRey, etc.)

lskin_by_xxml_basic.sql
content_copyfile_download
SELECT j.frn_lskinid, l.refname, j.frn_xxmlid
FROM z.z2.dbo.xxml_join j

	JOIN z.z2.dbo.xxml x
		ON x.xxmlid = j.frn_xxmlid

	JOIN lskin l
		ON l.lskinid = j.frn_lskinid

WHERE x.shareref LIKE '%rey%'