Problem with using an a subquery in an update

[neilgilbert1234]

Hi Everyone,
Im sure this is an easyone, im a newbie to anything half complex in sql so any help would be greatly appreaciated.
I have one table that has two values, i need to multiply those values and stick the result back into the table.
I have used the script below but getting an error:
"Subquery returned more than 1 value. This is not permitted when the subquery follows"

Script used:

update dbo.PCProjectEntry 
set ValueToBillInDocCurrency = (select ChargeRateInBaseCurrency*Quantity 
FROM dbo.PCProjectEntry as b where b.PCProjectEntryID = PCProjectEntryID)

[deepuv04]

Hi Everyone,
Im sure this is an easyone, im a newbie to anything half complex in sql so any help would be greatly appreaciated.
I have one table that has two values, i need to multiply those values and stick the result back into the table.
I have used the script below but getting an error:
"Subquery returned more than 1 value. This is not permitted when the subquery follows"

Script used:
update dbo.PCProjectEn try
set ValueToBillInDo cCurrency = (select ChargeRateInBas eCurrency*Quant ity
FROM dbo.PCProjectEn try as b where b.PCProjectEntr yID = PCProjectEntryI D)

hi,

try the following

update dbo.PCProjectEn try
set ValueToBillInDo cCurrency = ChargeRateInBas eCurrency*Quant ity

the above query will update all the values in the table


update dbo.PCProjectEn try
set ValueToBillInDo cCurrency = ChargeRateInBas eCurrency*Quant ity
PCProjectEntryI D = PCProjectEntryI D_val

will update specific record

[neilgilbert1234]

Yep that did the trick..... thanks very much.....