Post reply

Conversion failed when converting the varchar value 'No ' to data type int.

  • August 2, 2011 at 3:04 pm

    #1362669

    See my previous post.

    Unless you can change the left to inner join then this is not a viable solution.

  • August 2, 2011 at 3:23 pm

    #1362688

    Now it's successful... i repalced 'and ' with 'where'

    It worked...

    thanks..

  • August 2, 2011 at 3:27 pm

    #1362695

    Beginner_2008 (8/2/2011)

    Now it's successful... i repalced 'and ' with 'where'

    It worked...

    thanks..

    No it doesn't. What you just did is converted the left join to an inner join. When you put that filter in the where clause it filters out all the nulls... nullifying the left join.

  • August 2, 2011 at 3:27 pm

    #1362696

    Did you try this one?

    Ninja's_RGR'us (8/2/2011)

    left outer join address a with(nolock) on a.parent02aid = CONVERT(VARCHAR(50), m.acctid )

    I still think refactoring is the solution if it matters.

  • August 2, 2011 at 3:32 pm

    #1362703

    No, i tried checking the code and replaced "where"

    Worked out...

    thanks..

  • August 2, 2011 at 3:37 pm

    #1362708

    I'm not sure we have the same definition of worked.

    Either you need the left join or you don't. This filter cannot be moved around without changing the results.

  • August 2, 2011 at 3:49 pm

    #1362723

    what all i need is left outer join ...

    Thanks..

  • August 2, 2011 at 3:55 pm

    #1362729

    Beginner_2008 (8/2/2011)

    what all i need is left outer join ...

    Thanks..

    I'm happy you're happy

    L8rs.

  • August 4, 2011 at 5:02 pm

    #1364051

    Ninja's_RGR'us (8/2/2011)

    left outer join address a with(nolock) on a.parent02aid = CONVERT(VARCHAR(50), m.acctid )

    I still think refactoring is the solution if it matters.

    I would have to disagree Ninja's. This article explains the real root issue.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 9 posts - 16 through 24 (of 24 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy