creating a SP

[svibuk]

hitting a DB everytime on every navigation wont it cause performance issue

as i fetch data only as per request

this is the

@items varchar(5000),
    @status varchar(50),
    @ totalRowsInPage varchar(50),
    @finishedrecords varchar(50),
    @condition varchar(5000)

-- my  Session["condition"] contain WHERE 1=1 AND

 " SELECT  *  from (select top    " + totalRowsInPage.ToString() + "  *  from
(select top (" + finishedrecords.ToString() + ")" + Session["items"] + "  from EMPLOYEE
 Session["condition"]
               
                order byNAME )
  as T1 order by T1.NAME  DESC) as T2 ";

order by NAME  ASC

getting erroe

[Hack]

What is the error?