SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'WINV_FamiliaArticulo_GetCombo') )
DROP PROCEDURE WINV_FamiliaArticulo_GetCombo
GO

CREATE PROCEDURE WINV_FamiliaArticulo_GetCombo --Carga la informacion a el combobox
AS
BEGIN
	select codigo=dbo.FullFamiCode(id_fami),LTRIM(RTRIM(descripcion))descripcion
	from STOKFAMI 
	order by id_fami
END
GO

--SELECT codigo=dbo.FullFamiCode(id_fami),descripcion,id_fami FROM STOKFAMI