Try this in your query window: create procedure usp_prioritybid ( @BID int ) as SELECT * FROM PriorityStuff WHERE BID = @BID AND PriorityType = 'CP' OR PriorityType = 'Both' ORDER BY StartDate GO --- S R <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I'm trying to create this stored procedure in SQL > Server 6.5 and it keeps > giving me an 'incorrect syntax near @BID' error. > what am I doing wrong? > > @BID int > SELECT * FROM PriorityStuff > WHERE BID = @BID AND PriorityType = 'CP' OR > PriorityType = 'Both' > ORDER BY StartDate > > ______________________________________________________ > Get Your Private, Free Email at > http://www.hotmail.com > > ------------------------------------------------------------------------------ > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to > [EMAIL PROTECTED] with 'unsubscribe' > in the body. > __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
