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 |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-03-07 : 09:26:51
|
| HIleft join (select count(FBH.BILL_ID) as id, MAX(FBH.vfd_bod_Date) as date1 , FBM.PARTY_CODE ,FBM.BILL_PARAM_TYPE, FBH.BP_LIAB_CRNCY from dwh_staging..FBH left join dwh_staging..FBM on FBM.BILL_ID =FBH.BILL_ID where fbh.bill_stat in ('R') and FBM.PARTY_CODE ='25041777' group by FBH.BILL_ID, FBM.BILL_PARAM_TYPE , fbm.party_code,FBH.DUE_DATE , FBH.BP_LIAB_CRNCY having MAX(FBH.vfd_bod_Date)>FBH.DUE_DATETHIS IS MY SUBQUERY I NEED COUNT OF ID COLUMN IN MY MAIN QUERYSAME THIS KIND OF QUERIS ARE EXECUTED BASED ON DIFFERENT CRITERIA(ACTIVE,CLOSED,CRYSTLISED..)IN MY MAIN QUERYWHEN I CALLED THIS COUNT(ID) COLUMN IN MY MAIN QUERY I AM GETTING THIS ERRORConversion failed when converting the nvarchar value '812D57111210002' to data type int.PLS HELP ME |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
CONVERSOIN ISSUE IN SQL SERVER