<div>
&quot;DELETE * FROM RecognitionTest WHERE &lt;columnName&gt; = &lt;recordName&gt;&quot;<br />
This will delete the row based on the recordName in the field in this column.
</div>


<div>
the records i need deleting depend on the values in another table, your answer does not take that into account.<br />
<br />
Thanks<br />
Mick
</div>


<div>
I think the EXISTS below will work for you and the joins the right way round. Cheers, Andrew<br />

<pre><code class="code-1 nolinks" id="code-262978"><span>DELETE FROM [RecognitionsTest]</span>
<span>WHERE EXISTS (SELECT 'x' </span>
<span>              FROM [recognitions-original]</span>
<span>              WHERE [Recognitions-original].timestamp = RecognitionsTest.TimeStamp</span>
<span>              AND   [Recognitions-original].plate = RecognitionsTest.Plate</span>
<span>             )</span>
</code></pre>
</div>


<div>
Hi TextReport, in your code can I make 'x' &nbsp;= two fields e.g. (plate, timestamp)<br />
<br />
Thanks<br />
Mick
</div>


<div>
Hi TextReport, I tried your query but it just deletes all of the records. I've got the table back from a backup.<br />
the select part of the query brings back the correct number of records i want to delete (14322)<br />
<br />
Thanks<br />
Mick
</div>


<div>
try this<br />
<br />
Delete RT<br />
from [RecognitionsTest] RT<br />
right join [recognitions-original] &nbsp;RO<br />
on RT.TimeStamp = RO.timestamp and RT.Plate = RO.plate<br />
<br />
and in your question you say <br />
&gt;&gt;The records i want deleting are from the recognitions table only <br />
but in your select sql there is no table recognitions i assumed it it is [RecognitionsTest] . if it is [Recognitions-original] try this sql<br />
<br />
<br />
Delete RO<br />
from [RecognitionsTest] RT<br />
right join [recognitions-original] &nbsp;RO<br />
on RT.TimeStamp = RO.timestamp and RT.Plate = RO.plate<br />

</div>


<div>
and dont forget to test it within a transaction and after checking rollback/commit.
</div>


<div>
<div class="content wysiwyg-content">
Hi i would like to delete some records out of a table, the following query gets the records i would like to delete<br />
Select * from [RecognitionsTest]<br />
right join [recognitions-original] on RecognitionsTest.TimeStamp<wbr /> = [Recognitions-original].ti<wbr />mestamp and RecognitionsTest.Plate = [Recognitions-original].pl<wbr />ate<br />
<br />
The records i want deleting are from the recognitions table only I'm not quite sure of the syntax to delete these records<br />
<br />
Thanks Mick<br />

</div>
</div>


Hi i would like to delete some records out of a table, the following query gets the records i would like to delete
Select * from [RecognitionsTest]
right join [recognitions-original] on RecognitionsTest.TimeStamp = [Recognitions-original].timestamp and RecognitionsTest.Plate = [Recognitions-original].plate

The records i want deleting are from the recognitions table only I'm not quite sure of the syntax to delete these records

Thanks Mick


Deleting records

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.