sql - How to solve The multi-part identifier "r.StandardRate" could not be bound -
i getting following error query shown below:
msg 4104, level 16, state 1, line 37
multi-part identifier "r.resourceid" not bound.msg 4104, level 16, state 1, line 16
multi-part identifier "r.standardrate" not bound.
can please me figure out?
query:
select vnd.name vendorname, cct.name costcentrename, ct.name costtype, case when cct.isactive = 1 'active' else 'closed' end ccstatus, isnull(cct.t1code,'') t1code, cct.t2code, '' [month], convert(varchar, year(pf.period)) + '-' + convert(varchar, month(pf.period)) period, pp.parentproformano, pf.proformano, vac.trafiguraaccountcode, vac.pumaaccountcode, pli.finalamt ammount, ts.quantity quantity, r.standardrate standardrate, cmp.[text] proformastatus, '' billableuom, '' currency, bet.entity ccbilledentity, bcet.name ccbilledcompany, pbet.entity proformabilledentity, pbcet.name proformabilledcompany proformaparent pp join proforma pf on pf.proformaparentid = pp.id join proformacostcentre pcc on pcc.proformaid = pf.proformaid join costcentre cct on cct.id = pcc.costcentreid join proformalineitems pli on pli.proformaid = pcc.proformaid , pli.proformacostcentreid = pcc.proformacostcentreid join vendor vnd on vnd.id = pf.vendorid join costtype ct on ct.id = pli.costtypeid join vendoraccountcode vac on vac.vendormid = vnd.id , vac.costtypemid = ct.id join codemaster cmp on cmp.id = pf.statusid join billedentity bet on bet.id = cct.billedentitymid join entity bcet on bcet.id = cct.billedcompanyentityid join billedentity pbet on pbet.id = pf.billedentityid join entity pbcet on pbcet.id = pf.billedcompanyid join timesheet ts on ts.resourceid = r.resourceid
there no object in query named r
.
Comments
Post a Comment