troubleshooting Question

Multi-part identifier could not be bound

Avatar of rbhargaw
rbhargawFlag for United States of America asked on
Sybase DatabaseMicrosoft SQL Server 2005Microsoft SQL Server 2008
4 Comments1 Solution1198 ViewsLast Modified:
Hello,

I am trying to migrate Sybase stored procedures into SQL server 2008 using SSMA.  So I received the following error "Non-ANSI join operator cannot be converted in this statement" inside the code..and hence I am working on to remove this error..Here is what i am trying to do...
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

         UPDATE t
            SET
               status = c.statusId,
               descr = corr.descrip + ': ' + mdg.descrip
         FROM
            #t_trandata  AS t,
            dbo.Correspondence  AS c,
           -- dbo.CorrMeth  AS corr,
            dbo.MailDocGrp  AS mdg
           LEFT JOIN CorrMeth AS corr on corr.corrMethID = dbo.Correspondence.corrMethId
         WHERE
            t.holdTypeID = 13 AND
            t.holdId = c.holdId AND
           --c.corrMethId *= corr.corrMethID AND
            c.mailDocGrpId = mdg.mailDocGrpID
---------------------------------------------------------------------------------

But I am receiving the following error while running the SP

The multi-part identifier "dbo.Correspondence.corrMethId" could not be bound.

Let me know what I am doing wrong?

Thanjks
Existing Code:
----------------------------


         /* 
         *   SSMA error messages:
         *   S2SS0062: Non-ANSI join operator cannot be converted in this statement.

        UPDATE t
            SET 
               status = c.statusId, 
               descr = corr.descrip + ': ' + mdg.descrip
         FROM 
            #t_trandata  AS t, 
            dbo.Correspondence  AS c, 
            dbo.CorrMeth  AS corr, 
            dbo.MailDocGrp  AS mdg
         WHERE 
            t.holdTypeID = 13 AND 
            t.holdId = c.holdId AND 
            c.corrMethId *= corr.corrMethID AND 
            c.mailDocGrpId = mdg.mailDocGrpID
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros