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 Mike Lewis 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: *
- Users: rminnich85
- Order by date
-
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...- rminnich85
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
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...- rminnich85
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
