I am querying an excel file from my SQL server using OPENROWSET. I would like to query a specific sheet and a range of cells in the sheet. The problem I'm having is due to there being a space ...
I have a stored procedure on SQL 2000 that builds a temp table, and it also executes another stored procedure which returns a result set. I need to populate 3 of the fields in that temp table ...
Hello Experts,
I have table which has been updated with the newly added product information, all I wanted to do now is to copy all the data from this table and export into the table on the ...
Hi - trying to create a query that is the OPPOSITE of the query that is written below...seems easy enough but it isn't returning data.
I want to select all the records from G that do NOT have...
When I attempt to open a view in a SQL 2005 database I get the error "conversion failed when converting from a character string to uniqueidentifier". If I try to connect to the view through e...
The log file of one of the databases on my SQL SERVER 2000 has grown to over 123GB. I need to shrink it down and control it's growth. It's on a 250GB drive with only 15GB free.
In SQL Ser...
Hello,
I have a table which consist of 7 million rows & 110 columns with data type set to nvarchar (originally taken imported using SSIS + flat file) in SQL Server 2005. My goal is to give...
My sql script executes an mdx query as dynamic sql within a cursor. It works beautifully when I execute it in a query analyzer window. It also works when I run it within a sproc on the dev s...
When I check in Activity Monitor of SQL Server 2005 I also see few connections in sleeping status. I understand if C#.NET application is using Pooling, for performance reason SQL Server does n...
I have been trying to figure out why this wont work, any suggestions would be much appreciated.
Basically i want to check the DB system for the stored procedure 'sp_BasicSelectStatement' , ...
We are trying to use this function of SQL 2005 standard (openrowset) to bring in data from user imported / exported files.
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DAT...
Hi,
Issue: SQLServer.exe is utilizing the CPU 100% and using more Memory. How to fix this issue?
System:
RAM: 4 GB
Processor: 4
SQL Server Version: 2000 + SP4
OS Version: Windows...
Hello,
I have six tables in a golf reservation app I am writing for our club. My query almost works but gives results for more than one round. I want to filter on a particular roundid but in...
Hello,
I installed SQL Server 2005 but had some issues so had to remove it. So i uninstalled it and tried to reinstall
everything worked properly but when i try to install reporting servic...
I have a select statement which has some calculated column, which fails with the following error
Arithmetic overflow error converting expression to data type int.
and here is the calcula...
my website is down and come up with the following error message
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not alloc...
Hi,
I have two tables of news feed NewsHeader & NewsDetails
NewsHeader:
Time Header
10:15:34 AM News1
10:15:34 AM News1
10:15:34 AM News1
11:19:39 AM News2...
MSSQL 2000
I'm trying to write this simple SQL statement
SELECT CASE col2 WHEN NULL THEN -1 ELSE col2 + 4 FROM mySimpleTable.
Its not working. I understan I could do
SELECT ISNULL (col2 ...
Bulk inserting a file using at format file, e.g.
9.0
2
1 SQLCHAR 0 0 "\t\"" id c1 ""
2 SQLCHAR 0 0 "\"\n" text c2 "Latin1_General_BIN"
i.e reading a two column file, first an integer,...
When modifying an existing stored procedure, is it better to drop the existing stored procedure and recreate it or is it better to check for its existence, creating if not existing, and alter ...
I have a file that gets exported from an Excel spreadsheet. The time in the spreadsheet is saved in 24 hour format as a number in Excel (ex: 0900 or 1530). When import SQL simply sees these ...
Is it possible to downgrade a SQL 2008 database so that is can be restored in 2005?
Please can someone kindly help me with the following....
Specifically trying to work out how I can combine the results of a stored procedure with a SELECT statement....
Trying to achieve...
Good morning all,
I am getting the following error reported on one of the SQL servers, I have reported this problem to the SQL DBA but he is blaming it on the backup software. I can't see ...
Hi
I use microsoft SQL server 2000
I have a table of person names and I have the follwing SQL
SELECT FirstName FROM Names
This gives me one column with a row for each person.
Now I ...
