SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_act_introducers]
	@introducer_id as varchar(15) = '%'
AS

set nocount on

declare @id int 

if @introducer_id = '%'
	set @id = 0
else
	set @id = convert(int, @introducer_id)


select	*
from	vw_act_introducers
where	(@id = 0 or act_actor_id = @id)


GO
