Post reply

Error converting varchar to Float

  • March 8, 2012 at 12:19 pm

    #1456744

    SQLKnowItAll (3/8/2012)

    Change this:

    SELECT WarehousePickingGroup.PickingGroupDescription, SalesTransactionDtl.Transaction_No, SalesTransactionDtl.Line_No

    FROM SalesTransactionDtl

    INNER JOIN WarehousePickingGroup

    ON SalesTransactionDtl.PickingGroup_ID = WarehousePickingGroup.PickingGroup_ID

    To this:

    SELECT WarehousePickingGroup.PickingGroupDescription, SalesTransactionDtl.Transaction_No, SalesTransactionDtl.Line_No

    FROM SalesTransactionDtl

    INNER JOIN WarehousePickingGroup

    ON SalesTransactionDtl.PickingGroup_ID = WarehousePickingGroup.PickingGroup_ID

    AND SalesTransactionHdr.Warehouse_No = WarehousePickingGroup.Warehouse_No

    You mean add back in what I took out?? :hehe:

    It wasn't working with the INNER JOIN so I had commented it out, forgot to put it back in.

    Thanks for pointing out my mistakes again Jared! lol

    Now it works, couple more joins to add back in to see if I have finally gotten through this horrible code!

    thanks again for the help (I'll probably be back...) 😎

  • March 8, 2012 at 12:25 pm

    #1456746

    I'll be here! 😉

    Jared
    CE - Microsoft

Viewing 2 posts - 31 through 31 (of 31 total)

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