sqlexception was unhandled by user code Error

Question

0.00/5 (No votes)

See more:

this is the error:

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

My sql Query was:

SQL

USE [aspnetdb]
GO

/****** Object:  StoredProcedure [dbo].[sp_Permission]    Script Date: 04/29/2013 09:38:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Create procedure [dbo].[sp_Permission]
@RoleName nvarchar(50),
@SubMenu nvarchar(50)
as
begin
select Read_P,Write_P, Update_P, Delete_P from MenuMapping where RoleName=@RoleName and SubMenuId=(select SubMenuId from SubMenu where SubMenuLcation=@SubMenu)
end
GO


can anyone say possible solution for this... help me!!!

Posted 28-Apr-13 18:47pm

v surya dev

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sathishdevan · Answer 1 · 2013-04-28T18:51:00

Please use this code.

use in clause instead of equal to.

USE [aspnetdb]
GO

/****** Object: StoredProcedure [dbo].[sp_Permission] Script Date: 04/29/2013 09:38:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Create procedure [dbo].[sp_Permission]
@RoleName nvarchar(50),
@SubMenu nvarchar(50)
as
begin
select Read_P,Write_P, Update_P, Delete_P from MenuMapping where RoleName=@RoleName and SubMenuId in(select SubMenuId from SubMenu where SubMenuLcation=@SubMenu)
end
GO

Praveen Kumar Chauhan (PRK) · Answer 2 · 2013-04-28T18:52:00

XML

<pre lang="xml">
select Read_P,Write_P, Update_P, Delete_P from MenuMapping where RoleName=@RoleName and SubMenuId in (select SubMenuId from SubMenu where SubMenuLcation=@SubMenu)
</pre>


there should be 'in' not '=' near to 'SubmenuID in (query)' reason your subquery is contain more than one row so db is confuse which row it has to take, after putting in it will consider all row to check and give you result for all matching result for your subquery

sqlexception was unhandled by user code Error

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0