select operatorid, companyname, address as address1, address2, city, state, zipcode as zip, primaryContactId,
case when areacode is not null and areacode <> ''
then areacode + '-' + phone
else phone
end as phone
from tbl_opr_clientoperators with (nolock)
where operatorid =
and ownerid =
and fsltablecode =
select cdr_recordid, cdr_dstname as companyname, cdr_dstaddress1 as address1, cdr_dstaddress2 as address2, cdr_dstcity as city,
cdr_dststate as state, cdr_dstzip as zip, primaryContactId,
cdr_dstPhone as phone
from tbl_cdr_distributors with (nolock)
where cdr_recordid =
and ownerid =
and fsl_tablecode =
select mfr.mfr_name as companyname, mfr.postal_address as address1, mfr.postal_address2 as address2, mfr.postal_city as city, mfr.postal_state as state, mfr.postal_zip_code as zip,
'('+main_area_code+')'+main_phone as phone, 0 as primaryContactId
from tbl_bro_principals bp with (nolock)
inner join tblManufacturers mfr with (nolock)
on mfr.mfr_id = bp.mfrid
where bp.principalid =
select mfr.mfr_name as companyname, mfr.postal_address as address1, mfr.postal_address2 as address2, mfr.postal_city as city, mfr.postal_state as state, mfr.postal_zip_code as zip,
'('+main_area_code+')'+main_phone as phone, 0 as primaryContactId
from tblManufacturers mfr with (nolock)
where mfr.mfr_id =
select bro.broker_name as companyname, bo.broker_postal_address as address1, bo.broker_postal_address2 as address2, bo.broker_city as city,
bo.broker_state as state, bo.broker_zip as zip, bo.broker_phone_number as phone, 0 as primaryContactId
from tblBrokers bro with (nolock)
inner join tblBrokerOffices bo with (nolock)
on bo.Broker_ID = bro.Broker_ID
and bo.HeadquarterYesNo = 1
where bro.broker_id =
select dstname as companyName, dstaddr1 as address1, dstaddr2 as address2, dstcity as city, dststate as state, dstzip as zip,
dstphone as phone, 0 as primaryContactId
from tbl_DST_Distributors with (nolock)
where dstid =
select cho_name as companyName, cho_address as address1, cho_address2 as address2, cho_city as city, cho_state as state, cho_zipcode as zip,
cho_phone as phone, 0 as primaryContactId
from tbl_CHO_Operators with (nolock)
where cho_id =
select name as companyName, address as address1, address2, city, state, zipcode as zip, phone as phone, 0 as primaryContactId
from tbl_BYG_BuyingGroups with (nolock)
where uniqueId =
select ascname as companyName, ascaddress as address1, ascaddress2 as address2, asccity as city,
ascstate as state, asczip as zip, '('+ascPhoneAC+')'+ascPhone as phone, 0 as primaryContactId
from tbl_ASC_Associations with (nolock)
where asscId =
select companyName, address1, address2, city, state, zipcode as zip, '('+PhoneArea+')'+Phone as phone, 0 as primaryContactId
from tbl_MISC_Companies with (nolock)
where Misc_ID =
select '' as companyname, '' as address1, '' as address2, '' as city, '' as state, '' as zip, 0 as primaryContactId, '' as phone