Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rminnich85

    Trying to insert unique columns into table

    1. I am creating a table which contains all of the Vendor IDs in the following statement: select * into edi_temp from temp_po where VendorID in (001150, 010134, 010306, 010601, 010638, 010769, 010770, 011105, 011148...
  2. rminnich85

    Unable to concatenate varchar and int value. ReceivingString or binary data would be truncated.

    I am trying to add a assign a new PO number by concatenating an int and varchar. However I keep getting an error that the receiving string or binary data would be truncated. Here is the code it is complaining about: UPDATE #temp_po set updatedPO = @PONum + CONVERT(VARCHAR(20), @newPO) where...

Part and Inventory Search

Back
Top