SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_nm_types_addresses]
	@type_code AS ais_code_short = '%'
AS
BEGIN
	SET NOCOUNT ON;
	
	select *
	from nm_types_addresses
	where @type_code = '%' or nmtadr_type_code = @type_code
	
END
GO
