This can be done using sub-query

Using TOP

DECLARE @BATCH_SIZE INT = 10;

DELETE X

FROM (

SELECT TOP (@BATCH_SIZE) [COLUMN]

FROM [TABLE_NAME] M

ORDER BY [COLUMN] DESC

) AS X

Using OFFSET-FETCH (2012)

DECLARE @BATCH_SIZE INT = 10;

DELETE X

FROM...

This is a case of premature exclusion, nothing to worry about 😀

USE tempdb;

GO

DECLARE @inspection TABLE

(

INSPNO INT NULL

...

Could you supply a DDL with a sample records and the expected results?

Quick note, be careful not to use reserved keywords in this manner, that is the...

Came across this, thought it might help

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5ae34e9d-f0b2-4d32-90fa-a4faa0087889/accidentally-set-sql-server-max-memory-too-low?forum=sqldatabaseengine

dwain.c (3/27/2014)

---

You also get my seal of approval. 🙂

Tally Tables in T-SQL[/url]

Reference and link at...

Several ways to do this, options include using SSIS package, an OPENROWSET from destination, downgraded SQL Server import then upgrade and few more. Without more knowledge of the schema, constraints...

Jeff Moden (3/29/2014)

---

You should write another article, Eirikur. One on the very techniques that you've exposed in this thread. I was pretty sure that problem in the original...

This might help;

USE tempdb;

GO

CREATE TABLE dbo.TBL_XML_DOC

( XML_DOC_ID int identity(1,1) primary key clustered not null

,XML_DOCUMENT xml);

GO

INSERT INTO dbo.TBL_XML_DOC(XML_DOCUMENT)

SELECT * FROM OPENROWSET(

BULK 'C:\Download\sdn.xml',

SINGLE_BLOB) AS x;

;WITH...

Prakash Heda (3/29/2014)

---

having issue sorting this data last date for every minute of data, while last date for min is coming fine, cant make last bid qty using same method,...

I have 2008R2, 2012 and 2014 on the same W7, all named instances, no problem 🙂

Jeff Moden (3/29/2014)

---

I notice that you did (what I think is) a nifty trick in the HRI(CT) CROSS APPLY that greatly simplified what I thought one might have to do...

elfresco1 (3/26/2014)

---

I am having problem trying to parse an XML field in a table because it is too complex for me. I need to get the data from the <HighRiskIndicators>,...

Here is a method that I have used for one off...

GilaMonster (3/28/2014)

---

INT has a higher precedence than string, the string will convert to int, so if that is an int column (which we don't know), then the query will be...