admin view documents thorugh department

See more:

C#

ASP.NET

SQL

stored-procedure

hey
Admin i.e john is linked to hr department when he signup then choose hr department and his data is store in uerss table and in this table there id is set as dep id =2 whihc is dep2
then i want when he login through his login id and password then he only hr documents not other document like finance ,computer science,marketing and i try this query
first i select dep id

ALTER procedure [dbo].[sphrdoc]

@UserName  nvarchar(50),
@Password nvarchar(50)
as
select DepID from Userss where UserName=@UserName AND [Password]=@Password