Wednesday 21 May 2014

How to get the list of User in Given Projects from Database

SELECT [PSU0]
      ,[PSU2]
      ,[PSU3]
      ,[PSU4]
  FROM [Project Name].[dbo].[IO_PSU]
order by psu2



SELECT usr2,usr3,usr8
  FROM [IoAdministration].[dbo].[IO_USR]
where usr0 in (SELECT rel1
  FROM [IoAdministration].[dbo].[IO_REL]

where rel3= 'Projectid'
and rel2 = 'USR')

order by usr2

No comments:

Post a Comment