Viewing 15 posts - 2,641 through 2,655 (of 3,221 total)
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...
February 15, 2009 at 8:50 am
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...
February 13, 2009 at 1:22 pm
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...
February 13, 2009 at 11:03 am
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...
February 10, 2009 at 12:23 pm
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...
February 10, 2009 at 7:33 am
What error ? Error number? Error message text?
February 10, 2009 at 6:51 am
Going from the future to the past -- though Jeff might use this as his "pork chop cannon" although the animated gif looks great...
February 8, 2009 at 9:14 am
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...
February 8, 2009 at 8:20 am
From BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f47eda43-33aa-454d-840a-bb15a031ca17.htm
OPENROWSET does not accept variables for its arguments.
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',...
February 6, 2009 at 3:11 pm
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...
February 6, 2009 at 2:45 pm
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:
...
February 6, 2009 at 11:58 am
Mark your T-SQL returns
$4.21 plus tax
not what I think the user wants
ZenDada - you can try this but note it will NOT function as you requested...
February 4, 2009 at 12:07 pm
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...
February 3, 2009 at 10:15 am
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...
February 2, 2009 at 5:49 pm
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...
February 2, 2009 at 5:15 pm
Viewing 15 posts - 2,641 through 2,655 (of 3,221 total)