Viewing 15 posts - 361 through 375 (of 3,221 total)
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$]')
...
July 27, 2012 at 3:03 pm
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...
July 27, 2012 at 2:14 pm
Try this blog post by Paul Randal, as a starting point.
July 27, 2012 at 2:05 pm
SQLRNNR (7/27/2012)
Not sure I agree with the "correct" answer.
+1
Each of us access the QOD for their own particular reason(s).
July 27, 2012 at 12:02 pm
Sean Lange
This one was a bit silly but not a bad reminder for some people who been getting pretty tense around the QOTD lately.
+ 1
July 27, 2012 at 7:35 am
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...
July 27, 2012 at 7:06 am
L' Eomot Inversé (7/25/2012)
I could remember 3 of the four answers, but on the mirroring one I was racking my brains to no avail, and...
July 26, 2012 at 8:39 am
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
July 24, 2012 at 7:18 am
Jeff Moden (7/21/2012)
SQLCrazyCertified (7/20/2012)
Jigneshal (7/20/2012)
I usually use #table in y stored proc. Which is the best to use in SP, #table or @Table variable?Thanks
If you are using this for small...
July 21, 2012 at 7:06 pm
Stewart "Arturius" Campbell (7/19/2012)
anthony.green (7/19/2012)
July 19, 2012 at 5:48 am
Nice question ... is actual straight forward .. no gimmicks .. no gotchas ...
July 17, 2012 at 9:17 pm
L' Eomot Inversé (7/17/2012)
It's a pity so many who can't be bothered to read the question think that that's a fault in the...
July 17, 2012 at 7:06 pm
rhythmk (7/16/2012)
weblorquins (7/16/2012)
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...
July 16, 2012 at 8:16 am
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...
July 15, 2012 at 10:30 am
Viewing 15 posts - 361 through 375 (of 3,221 total)