Problem in stored procedure in the last line plz help

[madhu7sudan]

HI here is the stored procedure

CREATE Procedure dm_deleteBBPost
(
@TopicID numeric,
@ForumID numeric

)
As
declare @netCount as int

BEGIN
Select @netCount=count(*) from tblBBPosts where TopicID=@TopicID

update tblBBForums set TotalTopics=TotalTopics-1,TotalPosts=TotalPosts-@netCount where ForumID=@ForumID

Delete From tblBBPosts Where TopicID = @TopicID
Delete From tblBBTopics Where TopicID =@TopicID

end
declare @pr_ForumsToday as varchar
declare @topicname as varchar

SELECT TOP 1 @topicname=Topics FROM tblBBTopics ORDER BY LastPostDate DESC
@pr_ForumsToday= ' <p><A href=''bbviewposts.asp?id="'+ TopicID +'>' +left(@topicname,50) + ' ...</a>" & "</p>")'
GO



i am getting error in the @pr_ForumsToday line
syntax error i think plz can any body help

[ck9663]

HI here is the stored procedure

CREATE Procedure dm_deleteBBPost
(
@TopicID numeric,
@ForumID numeric

)
As
declare @netCount as int

BEGIN
Select @netCount=count(*) from tblBBPosts where TopicID=@TopicID

update tblBBForums set TotalTopics=TotalTopics-1,TotalPosts=TotalPosts-@netCount where ForumID=@ForumID

Delete From tblBBPosts Where TopicID = @TopicID
Delete From tblBBTopics Where TopicID =@TopicID

end
declare @pr_ForumsToday as varchar
declare @topicname as varchar

SELECT TOP 1 @topicname=Topics FROM tblBBTopics ORDER BY LastPostDate DESC
@pr_ForumsToday= ' <p><A href=''bbviewposts.asp?id="'+ TopicID +'>' +left(@topicname,50) + ' ...</a>" & "</p>")'
GO



i am getting error in the @pr_ForumsToday line
syntax error i think plz can any body help

TRY:

set @pr_ForumsToday= ' <p><A href=''bbviewposts.asp?id="'+ TopicID +'>' +left(@topicname,50) + ' ...</a>" & "</p>")'

or

select @pr_ForumsToday= ' <p><A href=''bbviewposts.asp?id="'+ TopicID +'>' +left(@topicname,50) + ' ...</a>" & "</p>")'