SQL Sub query problem

Question

0.00/5 (No votes)

See more:

This SQL Query arises the following error :
"

XML

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

" Please explain me subquery and its use :

SQL

select (select L.lineName from tblLine L inner join TERMSHR..tblCompany C on L.CompanyCode=C.CompanyCode where L.Location='Mirpur'
) as LineName from tblDayMonthProductionEntry where ProductionDate between '1-Aug-2013' and '5-Aug-2013' and Location='Mirpur'

Posted 1-Sep-13 1:58am

Sumon562

Add a Solution

2 solutions

Add a Solution

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

Mike Meinz · Answer 1 · 2013-09-01T03:32:00

This query is the subquery. It returns more than one row. When you put it inside parenthesis and named it as a column with the As keyword, you designated it as a subquery.

SQL

(select L.lineName from tblLine L inner join TERMSHR..tblCompany C on L.CompanyCode=C.CompanyCode where L.Location='Mirpur') As LineName

Without seeing the DDL for the tables and understanding the output requirements, it is difficult to advise you on a solution.

Harold Villena · Answer 2 · 2013-09-01T03:39:00

The problem is that your query has multiple results, and each result must be in his own result row.
Yor query is trying to get all results in a unique row.

This sample can help you.

Select lineName
From (select L.lineName from tblLine L
inner join TERMSHR..tblCompany C on L.CompanyCode=C.CompanyCode
Where L.Location='Mirpur'
) as LineName
Where ProductionDate between '1-Aug-2013' and '5-Aug-2013' and Location='Mirpur'

SQL Sub query problem

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

SQL Sub query problem

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us