Here is the difference in the OPENROWSET command:

The latest version of EXCEL

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=d:\dasdgigs.xls',

'SELECT * FROM [dasdgigs$]')

...

I have seen that error when EXCEL is not installed on the server you are using, or your OPENROWSET command is using the incorrect driver with a relatively new release...

Try this blog post by Paul Randal, as a starting point.

http://www.sqlskills.com/blogs/paul/post/Inside-the-Storage-Engine-Using-DBCC-PAGE-and-DBCC-IND-to-find-out-if-page-splits-ever-roll-back.aspx

+1

Each of us access the QOD for their own particular reason(s).

+ 1

iBar

And as per moderator understanding and the points assigned to this question by SSC clearly means that this really worth it and this is what they also understand from their...

L' Eomot Inversé (7/25/2012)

---

Nice straightforward question, thanks.

I could remember 3 of the four answers, but on the mirroring one I was racking my brains to no avail, and...

You might want to read this posting and test if it applicable to your situation.

http://sqlserver-tips.blogspot.com/2006/09/mimicking-merge-statement-in-sql.html

Jeff Moden (7/21/2012)

---

SQLCrazyCertified (7/20/2012)

---

If you are using this for small...

Nice question ...

Stewart "Arturius" Campbell (7/19/2012)

---

anthony.green (7/19/2012)

---

I also read it as being Yes as the question didnt specify needing to delete or not delete the other snapshots, so in theory Yes I...

Nice question ... is actual straight forward .. no gimmicks .. no gotchas ...

L' Eomot Inversé (7/17/2012)

---

Nice straightforward question, clearly worded, no tricks.

It's a pity so many who can't be bothered to read the question think that that's a fault in the...

rhythmk (7/16/2012)

---

weblorquins (7/16/2012)

---

Delete From TableName

Where ID Not IN

{

Select MAX(ID) From TableName

Group By Col1, Col2...

}

By The help of Table name useing ID and the Group By we can delete the duplicate...

Is this what you desire ?

CREATE TABLE #T(ID INT, Unit INT)

INSERT INTO #t

SELECT 1,33 UNION ALL

SELECT 2,33 UNION ALL

SELECT 3,25 UNION ALL

SELECT 4,55 UNION ALL

SELECT 5,55

SELECT MAX(ID)AS 'id', Unit FROM...