Hello, I nee to write something that will transfer excel data into an SQL Server table. I have for another database application I wrote have it importing Excel spreadsheet data using cell by cell, row by row method. This is fully automated so the user can choose whatever spreadsheet they ...more >>

I have created a local temporary table (#Temp) and placed data in it. When I do: SELECT * #Temp The result is a set of rows with no columns. The SELECT statement is in the same procedure as the creation of #Temp; so I don't believe this is a scoping issue. Does that make sense? Thank ...more >>

I have a table, tbl1: create table tbl1 ([field1] [char] (16) NULL DEFAULT (' '), [field2] [char] (6) NULL DEFAULT (' ')). When I do a select * into tbl2 from tbl1, tbl2 does not have defaults. Is there any settings I have to keep on when I do a select * into? Any help will be appreciat...more >>

Hi, I'm sure this is a common problem.. to create a single field from a whole column, where each row would be separated by a comma. I can do this for a specified table, and column.. and I've created a function using VBA to achieve a more dynamic (and very slow) solution.. so I would like...more >>

I have the following query in Access: SELECT a.interest_parent_id, a.interest_element_id, b.alr_category_id AS interest_category_id, a.allergy_parent_id, a.allergy_element_id, c.alr_category_id AS allergy_category_id FROM (AllergyDrugPermutation AS a INNER JOIN alr_category_drug_map AS b ON ...more >>

Hi I'm trying to get some data fra a few tables, but I'm having a few problems. What I would like is this: The tables contain somn info on manuscripts and which process that manuascript has received. a manuscript is represented once in manuascript table that manuascript can have seve...more >>

...more >>

HI, I'm trying to insert records to a table using bcp command. The problem is the input file to the bcp is a text file that looks like this: Text file data: 1234 abc def ghi jkl mno Expected result: column1 1234 column2 abc def ghi jkl mno column3 null column4 N...more >>

I have two SQL Server stored procedures, PROC1 and PROC2. PROC1 has about 50 input parameters. PROC2 is the main procedure that does some data modifications and afterwards calls PROC1 using an EXECUTE statement. The input parameter values for PROC1 are stored in a table in my database. What I...more >>

hi, I am using SQL server 2000.and trying to resolve a deadlock issue.For this i am looking at SQL profiler.and while turning the trace on, i select Lock:Timeout event that needs to be traced.When done so, and executing other requests, there appears an entry which just mentions spid number, tex...more >>

Hi, I have an application that uses ADO & VBA to connect to SQL Server 2000 periodically like this: Dim conn As ADODB.Connection Set conn = New ADODB.Connection conn.ConnectionTimeout = 1 conn.ConnectionString = "Provider=SQLOLEDB;Server=MyServer;Database=MyDatabase;UID=My...more >>

Have just downloaded Toad for SQL Server, and by accident noticed that decimal and number fields have a dollar sign in the column values, only in Toad, not when I access these tables in Enterprise Manager. These columns in question are all autoincriment fields. Integer fields display correct...more >>

Hello all, I am doing some research on database conversions. Currently, I am interested in any information that would help me convert a database from one schema to another. This could be changes as minimal as adding a field to a table, or as large as deleting tables and changing relatio...more >>

I've always been mistified why you can't use a column alias in the group by clause (i.e. you have to re-iterate the entire expression in the group by clause after having already done it once in the select statement). I'm mostly a SQL hobbiest, so it's possible that I am not doing this in the m...more >>

Hi, I was wondering if you guys have any nth script to reads from table and outputs into a temp table subset of records. There was a nth tool I used to use it was GROUP1 which was written in C and it used to be very fast on nth -in a flat file. In this program we used to pass few paramaeters....more >>

Hello to all, Maybe first small introduction: - SQLServer 2000 SP3, - XP Pro EN, - ActiveX, - SP in database It should working like this. There is a instanse of an object working, which recieves "telegramms" from all clients, including SQLServer. In SP I set the special properities (s...more >>

Can anybody tell me why a) when running a stored proc from an asp page to return a recordset the command succeeds if the sp queries an existing table directly, but b) if the stored proc populates results into a different table, temporary table, global temp table, or table variable, then querie...more >>

Hi all, i have 97 honda CR-V with about 100,000 KM on it. i checked a doc on Honda web site and it said that 60,000 miles is point to change timing belt. compared with other Honda cars, it is pretty low. is it correct? if yes, do you know the reason?? thanks for your help, jj...more >>

I am having an issue with the way SQL server deletes data. I am trying to delete data from the DB and have it completetly gone. Here is what I did 1. added a table with a row of image data 2. inserted a text file into the row with a string i could search for. 3. opened the mdf file up...more >>

I am trying to create a dynamic SQL statement to create a view. I have a stored procedure, which based on the parameters passed calls different stored procedures. Each of this sub stored procedure creates a string of custom SQL statement and returns this string back to the main stored procedure...more >>

Hi all. Anyone know if sql server collects stats on how many full table scans a table gets and if so how do I get at those stats? Trying to track down poorly indexed tables / processes and I am guessing that sql server does have this data secreted away somewhere much like my db2 and informix dat...more >>

I'm hoping somebody can explain exactly what's going on here - I can't find it documented anywhere. Go to the Northwind database, and run the following SQL: create index IX_UnitPrice on [order details](unitprice) Now, turn on SHOWPLAN (either graphical or text, it doesn't matter), and run...more >>

I've been doing a lot of reading on this and my head is starting to hurt! It seems to be quite a feat to work out how much memory is actually being used by our server. I'm running W2K advanced server with SQL 2000 EE, 8GB of RAM, a min of 4GB and a max of 6GB is assigned to SQL server. I'm ...more >>

Hi, I have two, similar SQL Server 7.0 databases (in the same SQL Server Group) that I use as the backend for two Access 2000 front end applications - one is the live version, the other is the development version. The live version works fine. But the other version is read-only, i.e. no ch...more >>

Suppose I have two tables: CREATE TABLE Tab1 ( [A1] [int] NOT NULL, [A2] [int] NOT NULL, [B1] [int] NOT NULL, [B2] [int] NOT NULL) CREATE TABLE Tab2 ( [A1] [int] NOT NULL, [A2] [int] NOT NULL, [B1] [int] NOT NULL, [B2] [int] NOT NULL) I need to sum B1 and B2 values grouped b...more >>

I know there has to be a way to do this, but I've gone brain dead. The scenario..a varchar field in a table contains a date range (i.e. June 1, 2004 - June 15, 2004 or September 1, 2004 - September 30, 2004 or...). The users have decided thats a bad way to do this (!) so they want to split tha...more >>

I have full backup of database at 13:00 and another full backup at 17:00. I've made backup of transaction log at 17:05 When I try to restore database to state at 15:10 (point in time) , the dialogue in Enterprise Manager says that only time after 17:05 is valid. It seems to me that I'v...more >>

I have written a simple sql statement that I am running through the views in sql manager that retrieves data from a couple of tables by date range and a street name. I am getting the following run times for various date ranges. I did the above as a test because of a sudden reduction in retrie...more >>

Hi, I've tried without success to create a function where one of the parameters determines the final line of a select statement. The final line includes a 'where referencenumber in (@set)' line.. and @set is the parameter I wish to use which is a string. If the set is just one value, it...more >>

Hi there, I need some help in order to reduce the amount of code needed to implement the logging of INSERT and UPDATE in my application's database. In every table of my database I have four fields (CreatedBy, CreatedTime, ModifiedBy, ModificatedTime), these fields allow me to trace the use...more >>

Sorry if this is basic stuff but I'm new to MSDE and SQL. I am running MSDE as the server. I created a Microsoft Access Project and connected to the MSDE. Security is set to Integrated Security. When I try to open the database from an application I am writing I get a login error statin...more >>

hi ng, i am newbie to sqlserver and my problem seems simple, but i didn't find information about it: How can i display the RETURN @x value of a stored procedure in the sql analyzer of the sqlserver? thanks a lot, d...more >>

I have some users who would like to admin MSDE either from a browser based or Windows GUI tool because they do not have access to Enterprise Manager nor Query Analzer. Any recommendations for free tools? TIA John Dalberg...more >>

hey there, i'm trying to move one record from one table to the next, so i'm doing this by doing an insert into table, then delete from the previous table. Only thin g is on the insert i want to include a parameter. Can't work how to do this. Do you think i need to do another update query and ins...more >>

Hi Everyone, Apparently, I was being asked on a question, "Why don't we procure a desktop PC to run MS SQL Server 2000 rather than a buying a server?". From a Management point-of-view, buying a desktop PC is much cheaper than a server. However, I just wanted to understand that is it a viabl...more >>

We are looking to store a large amount of user data that will be changed and accessed daily by a large number of people. We expect around 6-8 million subscribers to our service with each record being approximately 2000-2500 bytes. The system needs to be running 24/7 and therefore cannot be shu...more >>

Dear all, I am new to this product and am willing to gain some knowledge. Please advise where to start and any books or free material available on the net. Thanks, Guju ...more >>

Hi there I have installed a SQL server standard edition and setup database and user. But i can't make the user NOT have access to the system dbs like master etc. Can somebody give me any directions to removing these rights for the user? The only thing he must access is his own database....more >>

If I insert 8000 byte of data, in the one of the column. now I want to read the data, is there any to see all the data, through select statement?...more >>

To Whom It May Concern: There is a piece of software that was needed to be installed to author reports in Reporting Services for SQL 2000. That piece of software is Visual Studio .NET 2003. I do not have that piece but I am able to get the beta version of Visual Studio .NET 2005 from Microso...more >>

I am inserting a record into a table that automatically generates unique ids (i.e. Primary Key). Is there anyway to return this id. As I am using this on ASP.net page and I really need the ID to update the page with the new details. I think on mysql there is something called LAST_INSERT_ID whi...more >>

Dear All, ORDER: ORD_ID, etc 1 2 3 4 ORDER_PROPERTY: OP_ORD_ID, OP_PRP_ID; OP_VALUE 1 155 no 1 169 wait 2 222 a 2 155 no 3 156 8 4 169 finished 4 155 no Want a list of ALL orders and show ORD_ID, OP_VALUE where OP_PRP_ID = 169 For the v...more >>

hi dan Some of my pals are facing a very rare kinda problem. Thay have a Java app that connects to a SQL server instance. Currently they are testing the app on the same comp where SQL server is installed. Few days back when they executed the app it couldnt connect to the database. But yesterd...more >>

hello myself avinash i am developing on application having vb 6 as front end and sql server 7 as back end. when i use insert query to insert data in table then the date value of that query is going as 01/01/1900 my query is as follows StrSql = "Insert Into SalesVoucher(TransactionID,Voucher...more >>

Hello, I have a question about sizing a MS-SQL server. What would happen if a transaction log is too small and is not allowed to grow? Would that influence performance? The transaction model is 'simple'. Regards, Walter...more >>

Hi, The more I read, the more confused I'm getting ! (no wonder they say ignorance is bliss) I just got back from the bookstore and was flipping through some SQL Server Administration books. One says, that to get the best query performance, youi do two things: 1. Cover all the col...more >>

Hi, I was so lost in Google Desktop Search last night, I kept on dreaming about the endless possiblisties of Google Search Technology. While I was in school I had read enough about DB information retrivial. Why can't google use their search technology to build Database engine ? Isn't that...more >>

Hi all. If we have a long running process for a database and the log is threatening to hit 100%, whats the best way to resolve it?...more >>

I'm running a DTS package on SQL Server. The source is MS Access and the target is Oracle. On a "Drop Table" command the process just hangs. There are no foreign keys on the table. Several tables have already been processed successfully by this time. I think I've ruled out corruption by ...more >>

We have an ASP application installed on one powerful Win 2003 and the SQL Server on another Win 2003. We have two copies of the application (identical, one for production and one for test purposes) that are operational. The 2nd application is connected to the same SQL Server but a test copy of...more >>

Hello everyone. I am using the NORTHWIND sample database in SQL Server 2000 and am trying to do the following query, but I'm not sure how to go about it: A query that shows the Product ID and Product Name for all products that been purchased by at least 3 different customers. Any ideas? I...more >>

If you place an image of your server on a rebuilt server, rename it and change the SID. You get an error message “UNABLE TO CONNECT” when you use the SQL Query analyzer on a desktop computer to connect to the server (hosting the image). If you add the server (hosting the image) to the Windows2...more >>

Does anyone know of a way to execute sql code from a dynamically built text field? Before beginning, let me state that I know this db architecture is built solely for frustration and I hope to make it better soon. Unfortunately, there is never a non-crucial time in which we can do an upgrade...more >>

I need to transfer some data from a file .txt to a SQL Server. I use bcp tool. The problem is about a column named 'FILE', that I've declared as: [FILE] VARCHAR(150) NOT NULL The command I launch is the following: bcp.exe EC_CUNEO01.PROJECT.ANTRACCIATO in data_file.txt -f format_file.fmt -...more >>

Hi, I'm trying to create a function that returns a table, however I want to use a local variable in there and enterprise manager ain't liking it! The error I get is number 156 'incorrect syntax near the keyword 'declare'.. hopefully this is just a simple thing where I've put it in the wrong...more >>

Hi all. Dorky question , but I am still relatively new to the world of ms database servers so bare with me. I am monitoring the page fault rate on a server and it runs at 100% almost all of the time. Can someone help me understand what that means?...more >>

I currently have two SQL server books for MS SQL Server 2000. One is a prep book for the 70-229 exam, the other is a Wrox book: "professional SQL Server 2000 Programming." I'm looking for more T-SQL books that give me PRACTICAL tips on writing advanced queries. What book do you refer to? Pleas...more >>