I am trying to run this stored procedre in MS sql server db
CREATE PROCEDURE ccim_getSponorSize( @chapter_id varchar(20)) AS
select count(*) as logid
where ccim_ChapterSponsors.Customer = @chapter_id
and ccim_ChapterSponsors.display_add ='1'
the display_add field is an int field
it doesn't give any syntax error but when i press apply it gves this error
Any help will be greatly appreciated