geoff.codd

If you could add the create table statement and some additional test data, so that those who are willing and able to assist you would not have to expend a...

Well I earned a BS (Mechanical Engineering) and while working as a development engineer I had problems having my budgets being approved by the bean counters. So as a...

I think I have gained an insight into why some of the users questions appear to be soooooo, well not intelligent. Last evening I attended a SQL User Group...

Taking from a Forum answer posted by Jeff Moden on 2/24/2008 this might be just what you need. Jeff posted this url

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

hope it helps - if not come back...

Yes there is a decline in civilizations trust. I can remember back in the mid to late 1960s when I would visit a steel mill superintendent to discuss equipment...

What error ? Error number? Error message text?

Going from the future to the past -- though Jeff might use this as his "pork chop cannon" although the animated gif looks great...

ritech.saluja - It is of small condolence to you, but I experience the same problem you are having. It was due to having previously installed the BETA release of...

From BOL at

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f47eda43-33aa-454d-840a-bb15a031ca17.htm

You could use dynamic sql to perform the import something like:

DECLARE @sql NVARCHAR(500)

Set @sql = 'INSERT INTO OPENROWSET(''Microsoft.Jet.OLEDB.4.0',...

Found this on another forum .. might it be your problem:

Solved!!! I kept on digging for answer and found a guy with the same problem: "In case anyone else may...

TomYum - Openrowset is a quick method to export to Excel but please note the requirements carefully

/*This is an example of how to output to Excel.

Requirements:

...

Mark your T-SQL returns

not what I think the user wants

ZenDada - you can try this but note it will NOT function as you requested...

I would be tempted to check the rowcount of records returned by the SELECT statement. For example:

Create table #Select (id int, Name varchar(10))

Insert into #Select values (1, 'Test')

Insert into...

Maarten Ter Laak - your question is overly broad in its scope. Would it be possible to post a short (a few rows along with column headers if they...

Idress.butt

As per you suggestion on using SQL Profiler! the situation is that we are hosting our Site on a dedicated server but we are using the SQL Server (shared) that...