swati agrawal

swati agrawal

  • NA
  • 20
  • 98k

store procedure showing error

Apr 1 2011 7:00 AM

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

Answers (2)