I ran the alter procedure and it worked very well for us. Thank you for all of your help.

Exactly right

PARTNUMBER LOGNO WH LOCATION

047749 485238 ...

These are all very helpful. However what happened was parts were being removed from a component electronically. Each part was removed once, this will store automatically in the...

Sorry, my question is how do I get the sum of the part numbers (varchar) in locations (varchar). Here is my code so far.

SELECT TOP...