User Profile

Collapse

Profile Sidebar

Collapse
MyDanes
MyDanes
Last Activity: Jul 23 '13, 06:27 AM
Joined: Jun 10 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • MyDanes
    replied to Sql Server Query help
    in SQL Server
    SELECT rowid, LEFT(ID, LEN(ID)-CHARINDEX('-', REVERSE(ID)))
    FROM a_part Got it ;)
    See more | Go to post

      Leave a comment:

    • MyDanes
      started a topic Sql Server Query help
      in SQL Server

      Sql Server Query help

      Ok I hope I can explain my dilema

      I need a sql select statement that will

      Select part_number from RCTOOL

      the column part_number has values such as

      BR643-0034-344-34
      AS54-54689
      A77360-3454-34456-4
      B7374-343-33-32-356-433-11-1

      In each of these cases ALL we want it to return is the values UP to the last -
      Desired result set from example above ...
      See more | Go to post
      • MyDanes
        started a topic Update from another table and use multi criteria
        in SQL Server

        Update from another table and use multi criteria

        Code:
        update PHYS_COUNT_TAG set COUNT_QTY= (SELECT qty from MC_PART_LOCATION where MC_PART_LOCATION.part_id = PHYS_COUNT_TAG.PART_ID
and MC_PART_LOCATION.location_id = PHYS_COUNT_TAG.LOCATION_ID)
        THE ABOVE DOES NOT WORK WIHT THE ERROR

        Msg 4104, Level 16, State 1, Line 4 The multi-part identifier "PCT.PART_I D" could not be bound. Msg 4104, Level 16, State 1, Line 5 The multi-part identifier "PCT.LOCATION_I D"...
        See more | Go to post
        Last edited by Rabbit; Jun 10 '13, 03:31 PM. Reason: Please use code tags when posting code.
        No activity results to display
        Show More
        Working...