I want to update a column in myTable. The value this column is set to
depends on a nested select statement which sometimes returns 0 rows
instead of 1. This is a problem since the column I'm trying to update
is set to refuse nulls. Here's a sample:
update myTable set myColumn = (Select
On 5/9/05, Mark Fenbers [EMAIL PROTECTED] wrote:
I want to update a column in myTable. The value this column is set to
depends on a nested select statement which sometimes returns 0 rows instead
of 1. This is a problem since the column I'm trying to update is set to
refuse nulls. Here's a
On Mon, 09 May 2005 12:57:41 -0400, Mark Fenbers wrote
I want to update a column in myTable. The value this column is set
todepends on a nested select statement which sometimes returns 0
rowsinstead of 1. This is a problem since the column I'm trying to
updateis set to refuse nulls. Here's
I want to update a column in myTable. The value this column is set to depends
on a
nested select statement which sometimes returns 0 rows instead of 1. This is a
problem since the column I'm trying to update is set to refuse nulls. Here's a
sample:
update myTable set myColumn = (Select