|
| Also, I need to put it into the following query. We are converting from
Pivotal to SalesForce and the later requires all names to be in one text
field.
Thanks.
SELECT a.fax as 'Fax', a.company_name as 'Account Name', a.phone as 'Account
Phone',
a.country as 'Account Site', a.annual_revenue as 'Annual Revenue',
a.barid as 'BARID', a.city as 'Billing City', a.country as 'Billing Country',
a.state_ as 'Billing State/Province', a.address_1 as 'Billing Street',
a.address_2 as 'Billing Street',
a.address_3 as 'Billing Street', a.zip as 'Billing Zip/Postal Code',
a.company_type as 'Company Type', a.number_of_employees as 'Employees',
a.rn_create_date as 'Legacy Created Date', a.company_id as 'Legacy ID',
c.first_name as 'Owner ID', c.last_name as 'Owner ID',
a.parent_company_id as 'Parent Company ID', b.practice_area as 'Practice
Area',
d.ship_to_city as 'Shipping City', d.ship_to_country as 'Shipping Country',
d.ship_to_state as 'Shipping State/Province', d.ship_to_address_1 as
'Shipping Street',
d.ship_to_address_2 as 'Shipping Street', d.ship_to_address_3 as 'Shipping
Street',
d.ship_to_zip as 'Shipping Zip/Postal Code', a.territory_code as 'Territory
Code',
a.vista_account as 'Vista_Account ID', a.www as 'Website'
from company a
join contact b on a.company_id = b.company_id
join order_ d on a.company_id = d.bill_to_company_id
Join employee c on c.employee_id = d.account_manager
--
Ray
"Ray" wrote:
> I am trying to combine three text fields into one field. This is a basic
> procedure I know but I cannot find help on the SQL Server 2000 SP4 online
> help. I think I am calling the procedure wrong.
>
> I want to combine the First_Name, Middle_name, and Last_Name into one
> column. Currently they are in three different columns.
>
> Does anyone have a query that will do this?
>
> Thanks from a Veteran and a beginning SQL Server User.
> --
> Ray
|
|