MS SQL

[timot]

Hey guys,

I've searched the web, and couldnt find any answer that can make me understand.

Let's say i have a table called tblLocation and there's no primary key in this table by the way.

They are connected to another table with LocationCode.

Now, i have 2 of the same LocationCode with the same columns.

How do i delete this?

Thanks.

 

[hellod9]

what do you want to delete, exactly?

how are they connected?

 

[timot]

hmmm nevermind... found a solution... TOTALLY forgot about the rowcount

SET ROWCOUNT 1

DELETE FROM #tmpTable
WHERE PrimaryKey = @variable
AND OtherField = @otherVariable
SET ROWCOUNT 0

Thanks all