17 kensington st | east perth | wa 6004 | Australia | w printforce.com.au | e rsingh@printforce.com.au 23 SalesRep2Mobile Select Top 1 phone1 from sales_team where name='$SelectSalesRep2$' and client_id=$AccountId$ SalesRep2Email Select Top 1 email from sales_team where name='$SelectSalesRep2$' and client_id=$AccountId$ SalesRepTitle Select Top 1 position from sales_team where name='$SelectSalesRep1$' and client_id=$AccountId$ Division select ' Rural' UNION select ' Commercial' UNION select ' Urban' Office select lastName from subdealer,dealer where ExtAccountId='$AccountId$' and subdealer.dealerid=dealer.dealerid and subdealer.subdealerid=0 Office Name select lastName from subdealer,dealer where ExtAccountId='$AccountId$' and subdealer.dealerid=dealer.dealerid and subdealer.subdealerid=0 Office Phone Select Top 1 Phone from dealer where ExtAccountId='$AccountId$' Office Fax Select Top 1 fax from dealer where ExtAccountId='$AccountId$' Office Address select Replace(Rtrim(address1 + ', ' + case when len(Suburb) > 0 then Suburb + ' ' else '' end + case when len(State) > 0 then State + ' ' else '' end + pincode),' ',' ') from dealer where ExtAccountId='$AccountId$' Office Phone Short SELECT Top 1 Right(Replace(phone, ' ', ''),8) FROM dealer WHERE ExtAccountID='$AccountId$' Office Email Select Top 1 email from dealer where ExtAccountId='$AccountId$' Website select url from dealer where ExtAccountId='$AccountId$'
RkJQdWJsaXNoZXIy MTI3ODI1