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

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 2005 Forums

Transact-SQL (2005)

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

Author

Topic

abhi05
Starting Member

1 Post

Posted - 2011-11-24 : 01:39:35

Hi Guys,
Below is my query :

With PaggedList (
[RowNumber]
,Postid
,Postuid
,Postdate
,Posthitcount
,Posturl
,Posttitle
,Postcontent
,Postcategoryid,
CategoryName,
Username,
Usertotalposts,
Userjoinedon,
Useremail )
as ( SELECT
ROW_NUMBER() OVER(ORDER BY A.Postid DESC) AS [RowNumber],
A.Postid
,A.Postuid
,A.Postdate
,A.Posthitcount
,A.Posturl
,A.Posttitle
,A.Postcontent
,A.Postcategoryid,
B.CategoryName,
C.Username,
C.Usertotalposts,
C.Userjoinedon,
C.Useremail
FROM tblMark AS A
Left OUTER JOIN Category AS B
on A.postcategoryid = B.Categoryid
Left outer join tblUser AS C
on A.Postuid = C.Userid ) Select * from PaggedList where [RowNumber] BETWEEN ( 1) AND ( 5) and
A.Posturl LIKE ( '%hi%' ) order by Postdate desc

I am getting error "The multi-part identifier "A.Posturl" could not be bound".

Please help me.. :(

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-11-24 : 02:10:28

Select * from PaggedList where [RowNumber] BETWEEN ( 1) AND ( 5) and
A.Posturl LIKE ( '%hi%' ) order by Postdate desc

should be

Select * from PaggedList where [RowNumber] BETWEEN ( 1) AND ( 5) and
Posturl LIKE ( '%hi%' ) order by Postdate desc

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources