Skip to Content
0
Former Member
Jan 19, 2012 at 05:54 AM

Sub Query Returned more than 1 value

49 Views

Hi All,

I have a query which i have used in a udf at row level. Its a test query applied in PO.

Declare @TaxAmt Decimal(16,3)
Set @TaxAmt  = ( SELECT  Sum(T0.[TaxSum])  FROM POR4 T0 Where Docentry = (Select Docentry = OPOR.Docentry from OPOR  INNER JOIN POR1  ON OPOR.DocEntry = POR1.DocEntry
Where DocNum = $[OPOR.DocNum] and Series = $[OPOR.Series] and POR1.[ItemCode]= $[POR1.ItemCode]) and statype = 8)
Select  @TaxAmt

This query gives error. Please let me know.

Thanks,

Joseph