
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_nm_products_variables]
	@variable_code AS ais_code_short  = '%' 
AS
BEGIN
	SET NOCOUNT ON

	SELECT	*
	FROM nm_products_variables
		inner join nm_products_variables_types on nmpv_type_code = nmpvt_type_code
	WHERE @variable_code = '%' OR nmpv_variable_code = @variable_code
END

GO
