<div>
Hmmm... Seemed to work for a bit, then...<br />
<br />
Msg 8114, Level 16, State 5, Line 1<br />
Error converting data type varchar to numeric.<br />
<br />
Now, I'm checking what it DID delete.
</div>


Hmmm... Seemed to work for a bit, then...

Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.

Now, I'm checking what it DID delete.

<div>
Okay. It didn't delete any. Still looking.
</div>


Okay. It didn't delete any. Still looking.

<div>
Thanks, guys. I've had to pass this on, but I appreciate your help!
</div>


Thanks, guys. I've had to pass this on, but I appreciate your help!

<div>
Thanks for the split. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the split.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
<pre><code id="code-10-28266760-1">Delete from Skus Where Sku &gt; '&quot; &amp; Sku.ToString(399999) &amp; &quot;'</code></pre>
<br />
I need to delete only those records that are numbered 399999 and up. Looks like the field isn't an integer, so I can't get it to work right. I found the line above online, but it deletes ALL the records.<br />
<br />
If it's easier, I can just delete all BUT the records where SKU &lt;= 2000<br />
<br />
I'll be trying to find an online solution while I wait.<br />
<br />
Thanks in advance!!
</div>
</div>


(CODE)

I need to delete only those records that are numbered 399999 and up. Looks like the field isn't an integer, so I can't get it to work right. I found the line above online, but it deletes ALL the records.

If it's easier, I can just delete all BUT the records where SKU <= 2000

I'll be trying to find an online solution while I wait.

Thanks in advance!!

SQL Syntax for Delete Entire Rows Mgmt Studio

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.