alter procedure prcEmpView
(
@Wherecondition nvarchar(4000)
)
as
begin
declare @sqlquery nvarchar(4000)
set @sqlquery=
'select
vEmpName,
vAddress,
vPhone,
vEmail
from tblEmployee
'+@Wherecondition
execute sp_execute @sqlquery
end
pls correct as soon as possible