Hi, sorry it has taken me so long to reply, I've been working on a pipeline(trying to make enough money to further education)... anyways yes I am interested in any...

Yes this was probably the issue. Users where in the system so SQL was most likely "protecting me from my own actions".

Thanks

strange....

i get 142 for the first 2 queries and 97 for the second set...

ok I have a fix that makes sense now...

I deleted out of my image table where manCode was equal to the manufacturer that had duplicate rows.

Then I re-insert the rows...

Well.... its kind of difficult to explain.

My situation was that I had inserted several rows into one table that were duplicates, but I had already related the table ID's to...

ok figured out what i needed to do, just bad programming to start with, thanks all

Thanks matt I think I am on the right path but when I run the query I get the error:

Msg 8117, Level 16, State 1, Line 1

Operand data type uniqueidentifier...

SQL 2005 management studio...

No sorry the only thing thats different is the GUIDs..

columns I have: 

ID----GUID

ManCode----nvarchar(3)

emImageID----int

description----nvarchar(250)

path----nvarchar(150)

Everything is the same on the duplicate rows except for the GUID... also not all rows...

sorry i wasn't clear, the whole row is duplicate except for the ID column which is a GUID..

sometimes there is 3 of a row and sometimes just one

I have tried something like:

select

distinct emimageid, * into image_3 from image_1st

well i got it, thanks for the push in the right direction... here was what i had to have:

Update

Document_Image

set

documentID

=...

well, this is almost what I needed but this set the documentID for all manufacturers not just the ones with a manufacturerCode = 'GRO'

Is there any way to just set the...

I am getting the same error except mine:

The LocaleID -1 is not installed on this system

..anyone know whats goin on here?

I had to re-work my code and re-think my approach but I think i've got it, thanks all

Ok I had to re-work my structure but I got it, thanks all