How to retrieve multipul values from stored procedure

See more:

DotGNU

SQL

.NET

SQL-Server

, +

Hi, Good Evening All,Here I am having a problem with stored procedure, that is, I created a stored procedure ,in that I am selecting values from multiple tables,that values I have to return from stored procedure to my code page.This is my code

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


alter PROCEDURE [dbo].[GetUserwithPermission] 
	(
	@userId uniqueidentifier,
	@policyid uniqueidentifier,
	@objectId uniqueidentifier,
	@ITID bigint
	)
AS
BEGIN
	
	SET NOCOUNT ON;
	declare @ubaAttributeValue varchar(250) 
	declare @ubaAttributeId uniqueidentifier
	declare @policyname varchar(250) 
	declare @permissionname varchar(250) 

   
      select @policyname=(select policyname from policy where policyid=@policyid )
      select @ubaattributeid=(select ubaattributeid from usrbyattributes where ubauserid=@userId)
      select @ubaAttributeValue=(select ubaattributevalue from usrbyattributes where ubaattributeid=@ubaattributeid and ubauserid=@userId)
      select @permissionname=(select permissionname from  WAAD_PermissionByGroup where wpbggroupid=@objectId)
  
   
END

GO

Here I am getting the error like this:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.