Hi,
I'm kumar.
i have been facing a problem.
please help me.
i have write a stored procedure using if else condition.
in this stored procedure if part perfectly work. but else doesn't work to me.
[u]here is the my stored procedure. please help me.</u>
Code:
CREATE PROCEDURE searchKword1
@kword varchar(50),
@ordBy varchar(20)
AS
create table #tempTest (ThreadID int, CatID int, UserID int, ThreadName varchar(100), creationDate varchar(30), CatName varchar(100))
if @ordBy='Thread.creationDate'
begin
insert #tempTest
select distinct Thread.ThreadID, Thread.CatID, Thread.UserID, Thread.ThreadName, Thread.creationDate, Category.CatName from Category, Thread join Message on Thread.ThreadID=Message.ThreadID where ((Message.BodyText like '%'+@kword+'%' or Thread.ThreadName like '%'+@kword+'%')) and ( (Thread.ThreadID=Message.ThreadID)and (Category.CatID=Thread.CatID) ) order by Thread.creationDate ASC
select count(*) as TotalRecordASC from #tempTest
drop table #tempTest
end
else if @ordBy='Thread.creationDateDESC'
begin
insert #tempTest
select distinct Thread.ThreadID, Thread.CatID, Thread.UserID, Thread.ThreadName, Thread.creationDate, Category.CatName from Category, Thread join Message on Thread.ThreadID=Message.ThreadID where ((Message.BodyText like '%'+@kword+'%' or Thread.ThreadName like '%'+@kword+'%')) and ( (Thread.ThreadID=Message.ThreadID)and (Category.CatID=Thread.CatID) ) order by Thread.creationDate DESC
select count(*) from #tempTest
drop table #tempTest
end
GO
If condition doesn't work else part Please help me
