e mai mult decat perfect.....dureaza 2 sec

multumesc mult.

alex.

P.S. asta e celalalt view...asa ca idee

create         view [dbo].[vw_CRMImportClienti]
as
select cus.id acc_id, isnull(cus.name,'-') acc_name, isnull(cus.afm,'-') acc_new_codfiscal,
 cus.phone11 acc_telephone1, cus.phone12 acc_telephone2, cus.fax1 acc_fax,
 cus.webpage acc_websiteurl, cus.email acc_emailaddress1,'Adresa de facturare' acc_address1_name,
 cus.city1 acc_address1_city, cus.street1 acc_address1_line1, cus.district1 acc_new_judet_sector,
 cus.zipcode1 acc_address1_postalcode, cus.phone22 acc_address1_telephone1,
 1 acc_address1_addresstypecode, --1 = Bill to address
 cus.remarks acc_description, cus.crdlimit acc_creditlimit,
 'Adresa de livrare' adr_name, isnull(cus.street2,'-') adr_line1, cus.city2 adr_city,
 cus.zipcode2 adr_postalcode, 2 adr_addresstypecode, --2=Ship to address
 cus.phone21 adr_telephone1, cus.telex2 adr_telephone2, cus.telex1 adr_primarycontactname,
 resp.name per_lastname, '-' per_firstname, resp.privatephone per_telephone1,
 resp.mobile per_mobilephone, resp.email per_emailaddress1, resp.remarks per_jobtitle,
 isnull(right(code,len(code)-3),'-') acc_new_codatlantis, cus.r_CRMGUID acc_GUID ,
 cus.comid, cus.braid
from

(select * from

(select cus.* from customer cus

where cus.isactive = 1)y

union all

select * from customer where afm is null and isactive = 1) cus
left join custrespperson resp on cus.id = resp.perid

alex.