store procedure showing error
I have a sp .when m executing it showing message Command(s) completed successfully. but when m calling it showing error dat is
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
sp is given below .plz help
alter PROCEDURE Search
@General varchar(50)
--@country varchar(50)
AS
BEGIN
declare @tbl1 as table (name varchar(50),Id int,discription varchar(100),profilePic varchar(50),comments varchar(50),DateProfileCreate varchar(50),email varchar(50),Category varchar(50),country varchar(50),TypeU varchar(50))
declare @countArtist int
declare @countVenue int
set @countArtist=(select count(*) from tbl_artists where tbl_artists.name like '%@General%' or discription like '%@General%')
set @countVenue=(select count(*) from tbl_venues where tbl_venues.name like '%@General%' or discription like '%@General%')
if(@countArtist >0) and(@countVenue =0)
begin
insert @tbl1 (name ,Id ,discription ,profilePic ,comments,DateProfileCreate,email,Category,country,TypeU)SELECT tbl_artists.name,tbl_artists.ArtistId,tbl_artists.discription, tbl_artists.profilePic, tbl_artists.comments,convert(varchar(50),tbl_artists.DateProfileCreate,105)as DateProfileCreate, tbl_artists.email,tbl_artists.Category,tbl_artists.country,(tbl_artists.Type) as TypeU FROM tbl_artists where tbl_artists.name like '%@General%' or discription like '%@General%'
end
select count(*)from @tbl1
End