June 15, 2006 at 9:24 am
Hi Everybody
I am running an application on Sql Server 2000 Personal Edition on windows Xp sp2 mechine then i am getting an error where as the same application on sql server 2000 enterprise edition windows 2000 server it is working properly. Is the problem with the xp ?
Thanks in Advance.
Error:Subquery Returned more than 1 value this is not permitted when the subquery follows = , etc....or when the subquery is used as an expression. This error i am getting only on Sql Server installed on XP system.
rgds
Ramaa
June 15, 2006 at 10:52 am
My guess is that the data on the two systems is different. If you remove the sub-query and run it by itself, do you get one result on the production box and more than one on your xp machine?
June 15, 2006 at 12:06 pm
If the query and data are the exact same, then it's an issue between the Personal and Enterprise editions.
-SQLBill
June 15, 2006 at 7:06 pm
Can you post the query you are using and possibly the DDL (Data Definition Language) for the objects it references? That might help.
K. Brian Kelley
@kbriankelley
June 15, 2006 at 9:27 pm
The error you are getting is because there is statement using an equal operator with a subquery like:
select * from myTable where id = (Select id from myOtherTable)
the statement "select id from MyOtherTable" is returning more than one record.
or
select myColumn,(select myOtherColumn from myOtherTable) MyOtherColumn from MyTable
the statement "select myOtherColumn from myOtherTable" is returning more than one record.
as bkelley stated it would help if you post a sample of the query... in the interim if you run your subqueries that are part of an = operator or column seletion you'll probably find that on the SQL Server Enterprise you get one row back while the same query on the Personal (XP) will return multiple rows...
I've never heard of the XP vs 2000 causing this issue.
-
June 15, 2006 at 10:03 pm
Hi Everybody,
Thank You all for your response.
I am using the same database on Sql server on xp sql server on windows 2000, application is also the same.
I think there may be some version conflict between server as well as operating system.
I agree with bill, some of the sql server versions are not supporting on xp systems.What is the work around? Any Idea?
Ramaa
June 15, 2006 at 10:20 pm
Dear ,
Will u post the query .Then we can help u in best way.
from
Killer
June 17, 2006 at 9:01 am
Some of the versions aren't supported, true. You can't run Standard or Enterprise edition on Windows XP. However, you can run Developer, which is basically Enterprise in a specially licensed mode through an MSDN subscription. However, with a few notable exceptions, the engines between the versions aren't different. Unless there is a bug, the query should run the same on the server and XP. That likely indicates a data difference. However, until you post the query, that's hard to say.
K. Brian Kelley
@kbriankelley
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply