SQL语句问题

create Proc Proc_getawardinfo  

@pagesize int,    

@currentpage int,  

@depname varchar(200)

as    

declare @sql varchar(max)    

set @sql='select awa_empid as 工号,emp_name as 姓名,awa_date as 奖励日期,awa_money as 奖励金额,emp_name as 批准人,Prm_name as 奖励方式, pri_name as 奖励类别,dep_name as 部门   

from awardemp inner join employee on awardemp.awa_empid=employee.emp_id   

inner join department on employee.emp_departid=department.dep_id   

inner join prizemethod on prizemethod.prm_id=awardemp.awa_modeid   

inner join prizetype on awardemp.awa_prizeid=prizetype.pri_id   

where dep_name='+@depname+' and awa_empid in(select top '+convert(varchar,@pagesize)+' awa_empid from awardemp where awa_empid in(select top '+convert(varchar,@pagesize)+' awa_empid from awardemp where awa_empid in(select top ' +convert(varchar,(@pagesize*@currentpage))+' awa_empid from awardemp order by awa_empid)order by awa_empid desc)order by awa_empid)'  



exec(@sql)

exec Proc_getawardinfo 10,1,'采购部'

报错：列名'采购部'无效