In processes of upgrading SQL Server 2000 to SQL Server 2008 I held up with one issue
I am not a good pragrammer If some helps me how to modify this query,realy it help for me.
"Outer join operators *= and =* are not supported in 90 or later compatibility modes"
Here this query
SELECT Brnd.Name, Dev.Devype FROM Prd,PrdRel, Rel, RelVer, DevSoft, DevCla, Dev, Brnd,OVer
WHERE Prd.ID = PrdRel. Product
AND Rel.ID = PrdRel.Release
AND RelVer.Release = Rel.ID
AND DevSofte.ReleaseVersion = RelVer.ID
AND DevSoft.DeviceClass = DevCla.ID
AND DevCla.ID = Dev.DeviceClass
AND Brnd.ID = Dev.Brand
AND OVer.ID =* Dev.OSVersion
AND RelVer.Latest = 'Y'
AND Prd.ID = @Product
AND Rel.OS IN (@OS)
Please some help me how to code to come out from the problem.
your help going to be greate for me.
View Complete Post