A quick search yielded the following:

Finding and removing duplicates, Chris Cubley - article 

Removing Duplicate Rows, Neil Boyle - article 

Deleting Duplicate Records, Sureshkumar Ramakrishnan - article 

Finding...

Oh, I agree.  I just wanted to give him a hard time...

The location given by the error is not always the exact location where the probelm lies.  That is why Ninja's RGR'us suggested commenting one half of the code.  In my...

You give him his props, and still he wants more...

You could try this with or without the WHERE clause - I don't know how big your table is and whether this will help..

UPDATE tblProject SET

     tblProject.status =...

Isn't the from a previous post? Converting date of birth to Age   Why not continue with that previous one so people have a tract of thought to follow?

Remove the last comma before the FROM statment

change:

loc4 = [supv #], companycode = eui_director_list.company,

to: 

loc4 = [supv #], companycode = eui_director_list.company

No biggie.  You will get very...

Excellent addition! 

You may want to wrap this in a test for existence... 

DECLARE @TableName varchar(100),

               @sql varchar(1000) 

SET @TableName = 'dbo.YourTableName'

SET @sql =

'IF EXISTS(...

No way...   You will have to comment out each line and see where your data choices do not work...  We do not know...

I'm not sure what you are going after.  If this is a display issue, you may want to handle this in your front-end.  Otherwise, I do not see the problems...

I'm not clear about your question.  This gives me the same results without "hardcoding" the numbers in text as the field values...  (I also stripped the extra DATEDIFF with zero...

Thanks bud!  I will look at this later today. 

Ken,

I tried a quick test and I am not seeing your solution work correctly.  Please indicate where I am going wrong.  I have a select statement in front of...