Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 help query

Author  Topic 

kabon
Starting Member

48 Posts

Posted - 2013-05-24 : 04:27:16
I have query like this:

SELECT PD.RECID,
dbo.[f_ZeroLeading] ((ISNULL(convert(numeric(16,2),C.XMLRECORD.value('(/row/c22)[1]','NVARCHAR(100)')),'0'))
+(ISNULL(convert(numeric(16,2),C.XMLRECORD.value('(/row/c22 [@m=2])[1]','NVARCHAR(100)')),'0'))) AS OUTSTANDING_BAL
FROM FBNK_PD_CAPTURE as PD with (nolock)
left join FBNK_PD_PAYMENT_DUE C on PD.RECID COLLATE Latin1_General_100_BIN2 = (SELECT REPLACE(C.RECID COLLATE Latin1_General_100_BIN2 , 'PDLD','PDCA') FROM FBNK_PD_PAYMENT_DUE C WHERE C.RECID COLLATE Latin1_General_100_BIN2 LIKE 'PDLD%')

and have still error.
Do you have idea for this query?

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-05-24 : 05:28:09
Check whether you have returned more than one record for sub query ?
SELECT REPLACE(C.RECID COLLATE Latin1_General_100_BIN2 , 'PDLD','PDCA') FROM FBNK_PD_PAYMENT_DUE C WHERE C.RECID COLLATE Latin1_General_100_BIN2 LIKE 'PDLD%'

Let us know the result...
And also post us the error message

--
Chandu
Go to Top of Page
   

- Advertisement -