Number 4 is an actual duplicate, (which I am 'assuming' your table allows), but the others have the same code, but slightly different names.  Actually, #3 is totally independent, so...

They also have scope issues.  But, for quick a dirty, they are great!  And, if you do not have large sets of data, they work dandy as well as Indexing...

Look up the SUBSTRING function.  I believe that will give you what you need...

Are you filling in blanks?  Can you give us a set of your data?  (This may not require a full description of the tables, expected and actual results - sounds...

Have you run this query?  You should not get multiple values for a one-to-one relationship, hence DISITINCT should not be necessary. 

It seems to me you think backwards from parsing a string.  In other words, if I have an SP with a string passed in delimited by | [ pipe ],...

  I changed my first post... 

Can you show me an example of two identical column names in one table?  Thanks

If your @Variables are already populated.  Generally after Declaring the Cursor, you populate your variables, check for errors, and run you actions through the cursor.  If you are getting an...

If you can keep from using DISTINCT, that is always best, (generally that indicates a problem with relationships of lack of constraints). 

You may want to post your table structures,...

I completely misunderstood your post. 

IF EXIST( SELECT TOP 1 * FROM Tsource)

BEGIN

     ... do your work

END

ELSE

BEGIN  

     RETURN

END

You may be missing an underscore: SET ANSI_WARNINGS OFF

What error are you getting?  (Sometimes you will see errors in Query Analyzer that will not effect your application...) 

If you Delcare a @TableVariable, you do not need to drop it to re-run the script...

[OMG!  I did not realize so many of us got the same thing... too funny]  I do not get your results: 

DECLARE @employees TABLE( [id] integer, employee varchar(10))

INSERT INTO...

You could try the following: 

SELECT [MVG T003 - Eliminate outliers from T001].StdVin,

              GRP.FirstOfMODELYEAR,

              GRP.FirstOfMAKE,

              GRP.FirstOfSERIES,

              GRP.FirstOfBODYSTYLE,

              GRP.STDEVAUCNETPRICE,

              GRP.CountOfStdVin,

             GRP.AvgOfCurValue,

             GRP.VIC

INTO...