The Multi-part Identifier Could Not Be Bound.

hi,

i don't know what the prob with my code:

create table #tmpAllocation (

[ResourceID] int,

[Resource] varchar(50),

[WorkTeamID] int,

[WorkTeam] varchar(100),

[LineModuleId] int,

[AccountId] varchar(100),

[VpIdentifier] int,

[DivisionId] varchar(100),

[GroupId] int,

[Account/Version] varchar(100),

[version_id] int,

[1] numeric(9,5),[2] numeric(9,5),[3] numeric(9,5),[4] numeric(9,5),[5] numeric(9,5), numeric(9,5),[7] numeric(9,5), numeric(9,5),[9] numeric(9,5),

[10] numeric(9,5),[11] numeric(9,5),[12] numeric(9,5),[13] numeric(9,5),[14] numeric(9,5),[15] numeric(9,5),[16] numeric(9,5),[17] numeric(9,5),[18] numeric(9,5),

[19] numeric(9,5),[20] numeric(9,5),[21] numeric(9,5),[22] numeric(9,5),[23] numeric(9,5),[24] numeric(9,5),[25] numeric(9,5),[26] numeric(9,5),[27] numeric(9,5),

[28] numeric(9,5),[29] numeric(9,5),[30] numeric(9,5),[31] numeric(9,5),[32] numeric(9,5),[33] numeric(9,5),[34] numeric(9,5),[35] numeric(9,5),[36] numeric(9,5),

[37] numeric(9,5),[38] numeric(9,5),[39] numeric(9,5),[40] numeric(9,5),[41] numeric(9,5),[42] numeric(9,5),[43] numeric(9,5),[44] numeric(9,5),[45] numeric(9,5),

[46] numeric(9,5),[47] numeric(9,5),[48] numeric(9,5),[49] numeric(9,5),[50] numeric(9,5),[51] numeric(9,5),[52] numeric(9,5),[53] numeric(9,5))

insert into #tmpAllocation

select msp_resources.emp_code as [ResourceID],

msp_resources.res_name as [Resource],

WorkTeam.workteam_id as [WorkTeamID],

acc.account_name + ' / ' + WorkTeam.workteam_name as [WorkTeam],

line_module.line_module_id as [LineModuleId],

acc.account_id as [AccountId],

vp.vp_identifier as [VpIdentifier],

division.division_id as [DivisionId],

division.group_id as [GroupId],

Account.account_name + ' / ' + Version.version_name as [Account/Version],

Version.version_id as [version_id],

Version_Resources_Allocation.pct_allocation [pct_allocation]

from WorkTeam, Version_Resources_Allocation

pivot (sum(pct_allocation )

for Version_Resources_Allocation.week IN ([1],[2],[3],[4],[5],,[7],,[9],[10],[11],[12],[13],[14],[15],[16],[17],[18],[19],[20],[21],[22],[23],[24],[25],[26],[27],[28],[29],[30],[31],[32],[33],[34],[35],[36],[37],[38],[39],[40],[41],[42],[43],[44],[45],[46],[47],[48],[49],[50],[51],[52], [53])) as pvt

inner join Version_Resources_Allocation on WorkTeam.workteam_id = Version_Resources_Allocation.workteam_id

inner join WorkTeam_Resources_Assignments on WorkTeam_Resources_Assignments.resource_id = Version_Resources_Allocation.resource_id

and WorkTeam_Resources_Assignments.workteam_id = Version_Resources_Allocation.workteam_id

inner join calendar on calendar.year = WorkTeam_Resources_Assignments.year

and calendar.month = WorkTeam_Resources_Assignments.month

and calendar.year = Version_Resources_Allocation.year

and calendar.week = Version_Resources_Allocation.week

inner join Version on Version.version_id = Version_Resources_Allocation.version_id

inner join Account on Account.account_id = Version.account_id

--hierarchy joins

inner join line_module on line_module.line_module_id = WorkTeam.line_module_id

inner join Account as acc on acc.account_id = line_module.account_id

inner join vp on vp.vp_identifier = acc.vp_identifier

inner join division on division.division_id = vp.division_id

--Resources joins

inner join msp_resources on msp_resources.emp_code = Version_Resources_Allocation.resource_id

where Version_Resources_Allocation.resource_id in (select top 100 percent emp_code from #staffEmployees where id between ((@quota * (@pageIndex - 1) + 1)) and (@quota * @pageIndex) order by res_name)

and

(

(Version_Resources_Allocation.year = @startYear and Version_Resources_Allocation.week >= @startWeek and Version_Resources_Allocation.week <= (case when @startYear = @endYear then @endWeek else @maxWeeksInFirstYear end))

or

(Version_Resources_Allocation.year = @endYear and Version_Resources_Allocation.week <= @endWeek and Version_Resources_Allocation.week >= (case when @startYear = @endYear then @startWeek else 1 end))

)

and

(

pct_availability!=0 or (pct_availability is null and staffing_pct_availability!=0)

)

and

(

(WorkTeam_Resources_Assignments.year = @startYear and WorkTeam_Resources_Assignments.month >= @startMonth and WorkTeam_Resources_Assignments.month <=

case when @startYear = @endYear then @endMonth else 12 end

)

or

(WorkTeam_Resources_Assignments.year = @endYear and WorkTeam_Resources_Assignments.month <= @endMonth and WorkTeam_Resources_Assignments.month >=

case when @startYear = @endYear then @startMonth else 1 end

)

)

--and pct_allocation is not null

group by msp_resources.emp_code,

msp_resources.res_name,

WorkTeam.workteam_id,

WorkTeam.workteam_name,

line_module.line_module_id,

acc.account_id,

acc.account_name,

vp.vp_identifier,

division.division_id,

division.group_id,

Account.account_name + ' / ' + Version.version_name,

acc.account_name+ ' / ' + WorkTeam.workteam_name,

Version.version_id

I get:



The multi-part identifier "WorkTeam.workteam_id" could not be bound.

The multi-part identifier "WorkTeam.line_module_id" could not be bound.



Why?





Thanks,

Omri