
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_grpusg_usages]
	@group_code AS ais_code_short,
	@value AS ais_code_short = '%'
AS
BEGIN
	SET NOCOUNT ON

	SELECT	*
	FROM	grpusg_usages
	WHERE	usgu_group_code = @group_code
	AND		(@value = '%' OR convert(varchar, usgu_usage_id) = @value)
END



GO
