Consulta SQL no sale como quiero!!!!

[marcelor1988]

esta es la estructura de los datos:


Histórico:

Código:

id_articulos		int		Unchecked
id_secuencia		int		Unchecked
pr_costo		numeric(12, 3)	Checked
pr_costo_neto		numeric(14, 5)	Checked
ta_vari1		numeric(6, 3)	Checked
ta_vari2		numeric(6, 3)	Checked
ta_vari3		numeric(6, 3)	Checked
ta_vari4		numeric(6, 3)	Checked
ta_vari5		numeric(6, 3)	Checked
ta_vari6		numeric(6, 3)	Checked
ta_vari7		numeric(6, 3)	Checked
ta_vari8		numeric(6, 3)	Checked
ta_vari9		numeric(6, 3)	Checked
ta_vari10		numeric(6, 3)	Checked
ta_vari11		numeric(6, 3)	Checked
ta_vari12		numeric(8, 5)	Checked
ta_vari13		numeric(6, 3)	Checked
ta_vari14		numeric(6, 3)	Checked
ta_vari15		numeric(6, 3)	Checked
ta_vari16		numeric(6, 3)	Checked
ta_vari17		numeric(8, 5)	Checked
ta_vari18		numeric(6, 3)	Checked
ta_vari19		numeric(6, 3)	Checked
ta_vari20		numeric(6, 3)	Checked
ta_vari21		numeric(6, 3)	Checked
ta_margen		numeric(8, 5)	Checked
ta_iva			numeric(6, 4)	Checked
ta_imp_interno		numeric(6, 4)	Checked
pr_imp_interno		numeric(12, 3)	Checked
pr_arcor_a		numeric(14, 5)	Checked
pr_arcor_b		numeric(14, 5)	Checked
pr_arcor_c		numeric(14, 5)	Checked
ta_margen_meta		numeric(6, 3)	Checked
fe_act_costo		datetime	Checked
fe_act_preciovta	datetime	Checked
fe_act_preciovta_b	datetime	Checked
fe_act_preciovta_c	datetime	Checked

Info Actual del Articulo:

Código:

id_articulos		int		Unchecked
id_segmento		int		Checked
id_proveedor		int		Checked
id_negocio		int		Checked
id_subrubro		int		Checked
id_linea		int		Checked
de_articulos		varchar(40)	Checked
id_ubic1		int		Checked
id_ubic2		int		Checked
de_unidad		varchar(18)	Checked
ca_unidxbulto		smallint	Checked
ca_kilos		numeric(8, 2)	Checked
pr_costo		numeric(12, 3)	Checked
pr_arcor_a		numeric(14, 5)	Checked
sn_arcor		char(1)		Checked
pr_arcor_b		numeric(14, 5)	Checked
pr_arcor_c		numeric(14, 5)	Checked
ta_vari1		numeric(6, 3)	Checked
ta_vari2		numeric(6, 3)	Checked
ta_vari3		numeric(6, 3)	Checked
ta_vari4		numeric(6, 3)	Checked
ta_vari5		numeric(6, 3)	Checked
sn_pesable		char(1)		Checked
ta_vari6		numeric(6, 3)	Checked
ta_margen		decimal(8, 5)	Checked
ta_vari7		numeric(6, 3)	Checked
ta_imp_interno		numeric(6, 4)	Checked
ta_iva			numeric(6, 4)	Unchecked
ta_vari8		numeric(6, 3)	Checked
id_codigobarras		varchar(13)	Checked
id_empresa		varchar(16)	Checked
sn_activo		char(1)		Checked
sn_estadistica		char(1)		Checked
nu_enviocc		int		Checked
fe_ingreso		datetime	Checked
fe_act_preciovta	datetime	Checked
pr_costo_neto		numeric(14, 5)	Checked
ta_vari9		numeric(6, 3)	Checked
pr_venta_vjo		numeric(12, 2)	Checked
sn_unidad		char(1)		Checked
de_comentario		varchar(300)	Checked
ta_vari10		numeric(6, 3)	Checked
ta_vari11		numeric(6, 3)	Checked
de_extra		varchar(300)	Checked
ca_stkmin		numeric(8, 3)	Checked
ca_stkmax		numeric(8, 3)	Checked
id_codigobarras_bulto	varchar(13)	Checked
sn_prvta_fijo		char(1)		Checked
sn_stock		char(1)		Checked
ta_margen_meta		numeric(6, 3)	Checked
sn_stock_neg		char(1)		Checked
fe_act_costo		datetime	Checked
pr_imp_interno		numeric(12, 3)	Checked
id_art_proveedor	varchar(20)	Checked
id_secuencia		int		Checked
id_vehiculo		int		Checked
ta_vari12		numeric(8, 5)	Checked
ta_vari13		numeric(6, 3)	Checked
ta_vari14		numeric(6, 3)	Checked
ta_vari15		numeric(6, 3)	Checked
ta_vari16		numeric(6, 3)	Checked
ta_vari17		numeric(8, 5)	Checked
ta_vari18		numeric(6, 3)	Checked
ta_vari19		numeric(6, 3)	Checked
ta_vari20		numeric(6, 3)	Checked
ta_vari21		numeric(6, 3)	Checked
de_lista_precio		varchar(15)	Checked
id_art_linea		varchar(16)	Checked
nu_diasvalidez		int		Checked
id_unidmed		int		Checked
sn_envio		char(1)		Checked
sn_vendible		char(1)		Checked
ta_comision		numeric(10, 4)	Checked
ca_unidxbulto_prov	int		Checked
id_lista_prov		int		Checked
sn_combo		varchar(1)	Checked
sn_gen_codigobarra	char(1)		Checked
idseg			varchar(300)	Checked
fe_act_preciovta_b	datetime	Checked
fe_act_preciovta_c	datetime	Checked
de_ubicacion		char(10)	Checked

espero que eso te sirva. Muchas gracias!