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.
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_BALFROM 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 |
|
|
|
|
|