MS SQL

timot

Member
Feb 26, 2008
152
0
0
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.
 

timot

Member
Feb 26, 2008
152
0
0
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