Not quite sure what you are trying to achieve. 

This should work and you could make it an UDF. 

DECLARE @Routes TABLE( Location varchar(25))

INSERT INTO @Routes

SELECT 'NY Store1'...

I have always had better luck with Query Anaylzer than Enterprise Manager - especially when altering tables...

Agreed. Curses & Blessings of Dynamic SQL

Do you actually need the entire field to aggregate?  In other words, would 8000 characters be enough to actually know if the various records should be aggregated?  If this premise...

When you use Dynamic SQL, you generate a new SPID and it cannot see the @TableVariable you have created... You may either have to use a physical table or create...

I can't believe this is coming from you!  Generally you have the answers... 

I assume you verified that "Amount" is never NULL.  Also, why when you are converting the varchar...

Not sure where the "m" is coming from, but this will get you "delval.j" as well as "washin.m"

DECLARE @Mgmt_Personnel_Table TABLE( Full_Name varchar(100))

INSERT INTO @Mgmt_Personnel_Table VALUES( 'Mary Washington')

INSERT...

DECLARE @Mgmt_Personnel_Table TABLE( Full_Name varchar(100))

 INSERT INTO @Mgmt_Personnel_Table VALUES( 'Mary Washington')

SELECT LOWER( RTRIM( SUBSTRING( Full_Name, CHARINDEX( ' ', Full_Name) + 1, 6))) + '.' + LOWER( SUBSTRING( Full_Name, 1,...

I am getting the same return on your second select: "AB" versus 17 x's "AB". 

I do not use these functions much, but BOL indicate that case sensitivity is of...

I dunno - they were trying to call me Bulldozer there for a while...

Although I agree with Julie..., GREAT HACK, Ryan! 

Jeff,

I am missing something.  This returns multiple lines of the same data...

CREATE TABLE dbo.Pivot( [Name] varchar(15), Status varchar(15))

INSERT INTO Pivot SELECT 'NameOne', 'StatusOne'

INSERT INTO Pivot SELECT...

You need to include Col1 in the subselect "Query" to do this..

This is sooo simple and my head was just not getting around it!  Thank you!!! 

(I am still playing with this so no hardcoding is needed as I have run...

I don't understand what you are saying... 

If I try this with a RIGHT JOIN, it updates the Certificate fields, but not the Languages- Diploma fields... What is being overwritten...