SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

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

CREATE PROCEDURE WPOSS_SubFamilia_GetCombo --Carga la informacion a el combobox
AS
BEGIN
	Select desc_sufa, id_sufa From RestSufa Order by desc_sufa

END
GO

---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

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

CREATE PROCEDURE WPOSS_SubFamiliaFiltro_GetCombo --Carga la informacion a el combobox
		@id_fami INT
AS
BEGIN
	Select desc_sufa, id_sufa From RestSufa where id_fami = @id_fami Order by desc_sufa

END
GO

--	Select * From RestSufa Order by desc_sufa