 | |
Failing DTS 'Subquery returned more than 1 value. This is not permitted when the
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Failing DTS 'Subquery returned more than 1 value. This is not permitted when the -
02-27-2008
, 10:28 AM
|
Jay, It is telling you that your subselects are getting more than 1 row back. So, a couple of possibilities are: 1. The join and filter on the subselect are not as specific as they should be. That may mean investigating the data to determine what is being overlooked. 2. Yes, multiple rows are being returned in some instances, but it does not matter to you since you just want a single Provider_Key. (Perhaps you even know that the multiple Provider_Key values are identical.) In that case, use an aggregate to enforce returning a single row. For example: UPDATE dbo.FEIProviderStatus SET ProviderKey = (SELECT MAX(Provider.Provider_Key) -- MAX enforces a single value FROM dbo.Provider WHERE Provider.Datasource_ID = FEIProviderStatus.DatasourceID AND Provider.Provider_key <> 8602) RLF I received the following message from a DTS package that fails. 'Subquery returned more than 1 value. This is not permitted when the subquery [quoted text clipped - 14 lines] Jay |
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200802/1
#12
| |||
| |||
|
|
Jay, It is telling you that your subselects are getting more than 1 row back. So, a couple of possibilities are: 1. The join and filter on the subselect are not as specific as they should be. That may mean investigating the data to determine what is being overlooked. 2. Yes, multiple rows are being returned in some instances, but it does not matter to you since you just want a single Provider_Key. (Perhaps you even know that the multiple Provider_Key values are identical.) In that case, use an aggregate to enforce returning a single row. For example: UPDATE dbo.FEIProviderStatus SET ProviderKey = (SELECT MAX(Provider.Provider_Key) -- MAX enforces a single value FROM dbo.Provider WHERE Provider.Datasource_ID = FEIProviderStatus.DatasourceID AND Provider.Provider_key <> 8602) RLF I received the following message from a DTS package that fails. 'Subquery returned more than 1 value. This is not permitted when the subquery [quoted text clipped - 14 lines] Jay |
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200802/1
#13
| |||
| |||
|
|
Jay, It is telling you that your subselects are getting more than 1 row back. So, a couple of possibilities are: 1. The join and filter on the subselect are not as specific as they should be. That may mean investigating the data to determine what is being overlooked. 2. Yes, multiple rows are being returned in some instances, but it does not matter to you since you just want a single Provider_Key. (Perhaps you even know that the multiple Provider_Key values are identical.) In that case, use an aggregate to enforce returning a single row. For example: UPDATE dbo.FEIProviderStatus SET ProviderKey = (SELECT MAX(Provider.Provider_Key) -- MAX enforces a single value FROM dbo.Provider WHERE Provider.Datasource_ID = FEIProviderStatus.DatasourceID AND Provider.Provider_key <> 8602) RLF I received the following message from a DTS package that fails. 'Subquery returned more than 1 value. This is not permitted when the subquery [quoted text clipped - 14 lines] Jay |
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200802/1
#14
| |||
| |||
|
|
Jay, It is telling you that your subselects are getting more than 1 row back. So, a couple of possibilities are: 1. The join and filter on the subselect are not as specific as they should be. That may mean investigating the data to determine what is being overlooked. 2. Yes, multiple rows are being returned in some instances, but it does not matter to you since you just want a single Provider_Key. (Perhaps you even know that the multiple Provider_Key values are identical.) In that case, use an aggregate to enforce returning a single row. For example: UPDATE dbo.FEIProviderStatus SET ProviderKey = (SELECT MAX(Provider.Provider_Key) -- MAX enforces a single value FROM dbo.Provider WHERE Provider.Datasource_ID = FEIProviderStatus.DatasourceID AND Provider.Provider_key <> 8602) RLF I received the following message from a DTS package that fails. 'Subquery returned more than 1 value. This is not permitted when the subquery [quoted text clipped - 14 lines] Jay |
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200802/1
#15
| |||
| |||
|
|
Jay, It is telling you that your subselects are getting more than 1 row back. So, a couple of possibilities are: 1. The join and filter on the subselect are not as specific as they should be. That may mean investigating the data to determine what is being overlooked. 2. Yes, multiple rows are being returned in some instances, but it does not matter to you since you just want a single Provider_Key. (Perhaps you even know that the multiple Provider_Key values are identical.) In that case, use an aggregate to enforce returning a single row. For example: UPDATE dbo.FEIProviderStatus SET ProviderKey = (SELECT MAX(Provider.Provider_Key) -- MAX enforces a single value FROM dbo.Provider WHERE Provider.Datasource_ID = FEIProviderStatus.DatasourceID AND Provider.Provider_key <> 8602) RLF I received the following message from a DTS package that fails. 'Subquery returned more than 1 value. This is not permitted when the subquery [quoted text clipped - 14 lines] Jay |
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200802/1
#16
| |||
| |||
|
|
Jay, It is telling you that your subselects are getting more than 1 row back. So, a couple of possibilities are: 1. The join and filter on the subselect are not as specific as they should be. That may mean investigating the data to determine what is being overlooked. 2. Yes, multiple rows are being returned in some instances, but it does not matter to you since you just want a single Provider_Key. (Perhaps you even know that the multiple Provider_Key values are identical.) In that case, use an aggregate to enforce returning a single row. For example: UPDATE dbo.FEIProviderStatus SET ProviderKey = (SELECT MAX(Provider.Provider_Key) -- MAX enforces a single value FROM dbo.Provider WHERE Provider.Datasource_ID = FEIProviderStatus.DatasourceID AND Provider.Provider_key <> 8602) RLF I received the following message from a DTS package that fails. 'Subquery returned more than 1 value. This is not permitted when the subquery [quoted text clipped - 14 lines] Jay |
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200802/1
#17
| |||
| |||
|
|
Jay, It is telling you that your subselects are getting more than 1 row back. So, a couple of possibilities are: 1. The join and filter on the subselect are not as specific as they should be. That may mean investigating the data to determine what is being overlooked. 2. Yes, multiple rows are being returned in some instances, but it does not matter to you since you just want a single Provider_Key. (Perhaps you even know that the multiple Provider_Key values are identical.) In that case, use an aggregate to enforce returning a single row. For example: UPDATE dbo.FEIProviderStatus SET ProviderKey = (SELECT MAX(Provider.Provider_Key) -- MAX enforces a single value FROM dbo.Provider WHERE Provider.Datasource_ID = FEIProviderStatus.DatasourceID AND Provider.Provider_key <> 8602) RLF I received the following message from a DTS package that fails. 'Subquery returned more than 1 value. This is not permitted when the subquery [quoted text clipped - 14 lines] Jay |
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200802/1
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.