November 17, 2010 at 2:43 pm
Hi
when i try to run this query getting error malti part identifier Rpt.fullname couldnot be bound
select distinct
Rpt.fullname as Member Name
,Rpt.memid as Member ID
,e.orgeffdate as Org Effec
,e.effdate as Effective from RptAgeGrpVw rpt
inner join enrollkeys e on rpt.memid = e.memid
order by Member Name
Thanks
November 17, 2010 at 2:56 pm
try it like this:
select distinct
Rpt.fullname as [Member Name]
,Rpt.memid as [Member ID]
,e.orgeffdate as [Org Effec]
,e.effdate as Effective from RptAgeGrpVw rpt
inner join enrollkeys e on rpt.memid = e.memid
order by [Member Name]
The probability of survival is inversely proportional to the angle of arrival.
November 17, 2010 at 3:04 pm
Try this it should work
SELECT DISTINCT
Rpt.fullname as [Member Name]
,Rpt.memid as [Member ID]
,e.orgeffdate as [Org Effec]
,e.effdate as [Effective]
FROM
RptAgeGrpVw AS rpt
INNER JOIN
enrollkeys AS e
on
rpt.memid = e.memid
ORDER BY
[Member Name]
Scott
November 17, 2010 at 5:58 pm
Thanks
it worked.
but y it didnt work without []?
Thanks
November 18, 2010 at 4:09 am
.
but y it didnt work without []?
MSSQL query engine can not parse it correctly and column name can not have spaces in them. Rpt.fullname as Member Name this look like you are ref to more then col by use [] around [Member Name] it make correct
Scott
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply