Make sure you put an extra period before the Sheet name:

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

   'Data Source=c:\book1.xls;Extended Properties=Excel 8.0')...Sheet1$

Bryan

And of course we're all in the practice of not putting primary keys on tables! 🙂

About the diagrams-- I've only used it once to actually print out a diagram.  I...

Julie,

Another quick and dirty way to do this is to change the output type in Query Analyzer from "Results to Grid" to "Results to file."  It's an icon on the...

I just had to do this recently.  Don't let bcp scare you.  It's super fast.

Try pasting this into QA:

EXEC master..xp_cmdshell 'bcp DataBaseName..tblMyTablename out d:\Output.txt -c -q -t","', NO_OUTPUT

Change your database...

I just realized I don't even have to use a cursor, just:

SELECT YearMonth, Count(*) as DayCount

FROM tblDays JOIN #my_table

ON OneDate BETWEEN StartDate AND EndDate

GROUP BY YearMonth

Bryan

/*

Not Bad.  What I actually ended up doing was creating a table of every day like this:

OneDate      OneMonth OneYear YearMonth

1/1/2000         01          2000      200001

1/2/2000         01          2000      200001

1/3/2000         01          2000      200001

1/4/2000         01          2000      200001

1/5/2000         01          2000      200001

1/6/2000         01          2000     ...

With such a buildup I was expecting to see some results.  Since this was a year ago I just KNEW there were going to be the actual results...but wait..umm...where are...

When I export to Excel, the default format is MHTML, but you can SAVE AS a real Excel file that can be read in Excel 2000.

Bryan

That's right.  The CLIENT needs office XP or later to export to Excel.  I got around this problem by setting up a subscription to email the Excel file to the...

Yes, there's a way!! Go into Enterprise manager, open the table in design view, move your column to where you want it be.

Then click the "Save Change Script" icon...

Open the DTS package in EM; right click and choose "Save As...". For the Location, choose Visual Basic File.

Hope this helps!

Bryan

try

select SERVERPROPERTY ('productlevel')

this will give you the SQL Server Service Pack

Bryan