
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_pr_families_variables]
    @family_code ais_code_short,
    @variable_code ais_code_short = '%'
AS 

select	*
from	pr_families_variables
	inner join nm_products_variables on pfv_variable_code = nmpv_variable_code
	inner join nm_products_variables_types on nmpv_type_code = nmpvt_type_code
where	pfv_family_code = @family_code
		and ( @variable_code = '%' or pfv_variable_code = @variable_code)
GO
