[thelist] MSSQL 2000 -> 2005 change?
Joel D Canfield
joel at streamliine.com
Fri May 18 18:41:15 CDT 2007
I have 2000, client has 2005. I've scripted the db structure, which
script ran fine on the client's box. Connected remotely, copied data
from 2000 to 2005. Tried to run this query
select
e.firstname, e.lastname, e.didid, e.department, e.title,
o.number,
p.patchportnumber,
s.portnumber,
a.description
from
employees e
left join offices o on e.officeid = o.id
left join patchports p on p.officeid = o.id
left join switchports s on p.switchportid = s.id
left join assets a on s.assetid = a.id
it tells me that firstname, lastname, didid, department, title, number,
patchportnumber, and portnumber are not valid fields (it does not
mention description)
query runs fine on my 2000 box with identical structure and data. I
assume this is some fun new difference with 2005.
thoughts?
thanks
joel
More information about the thelist
mailing list