Microsoft SQL Server Forum

How do I get two values for two different fields in an insert statement values clause using one select? For instance: declare @test int @test gets assigned... insert into (id, field1, fname, lname) values

I'm trying to do a simple update like I have done countless times before. However, when I update the empty fields in this table it places a -1 into the field rather than the enterred value. It is indexed with duplicates allowed. It says that zero lenght is set to yes. What can I do about this?

I have a column named "LIST" in a table with strings like the following: 151231-1002-02-1001 151231-1001-02-1001 151231-1002-02-1002 151231-1003-02-1001 etc.... What I'd like to do is include an ORDER BY statement that splits the string, so that the order would be by the second set of four numbers

I am creating a document management systems using asp. I have been researching the different ways of handling the documents such as using the file system and storing the path in the db, and actually storing the document in the db. I like the idea of storing it in the database much better because I can allow users to manage documents...

My computer (connected to a domain) is having trouble connecting to the local MSDE when using 'local' or '(local)' as server name. The only way I can connect through DTS in Enterprise manager is when using domainname\localcomputername format. Any ideas? Karim

I have the following code to SUM based on one field but want to be able to not show rows which result is 0. ======================== SELECT Headers.employee_id AS Employee#, SUM(CASE Headers.scan_type WHEN 'I' THEN 1 ELSE 0 END) AS SIP, SUM(CASE Headers.scan_type WHEN 'F' THEN 1 ELSE 0 END) AS PUP, SUM(CASE Headers.scan_type WHEN 'Q' THEN 1...

Hello, I would like to know if it is possible to create a form in Access2000, which would function like a calendar for 8 operating rooms in hospital, showing which hours are those closed for a specific date. For this intersection I would like to be appeared the name of the doctor, the name of the patient and the kind of operation....

I have a table in mssql7 that has 7000000 record and I want to take 100000 records out of it and place them into the new machine with mssql2000. The new machine will also have the same table name, so I want to append the 100000 records into that table. Thanks, Royal344 -- Direct access to this group with http://web2news.com

Hi there, Could somebody post some simple example how one can refer to a column in the 'deleted' temporary table within a trigger definition ? Should the 'deleted' and 'inserted' temp tables be declared, or they are 'implied' ? I keep having this msg when trying to create a trigger "The column prefix 'deleted' does not match with a table...

I have two date fields, start_date and end_date. I'd like to subtract the two dates, and come up with a number (the number of difference between the two dates). What function is there to do this? I haven't been able to find anything in BOL.

Hi, We have setup a publisher and a distributor in SQL 2000 running SP3. Alongwith this we have setup a merge replication agent and its running successfully inside the same network. I allow anonymous subscriptions and the merge publication works successfully for anonymous pull subscriptions also. Now i am trying to setup the same...

Hello, I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machine with 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU power. I do NOT load the DB in any way with queries. Obviously this leads to all kinds of software not working well anymore. Does anyone know how to lower the CPU power used? Please help!? ...

Hi All I need to aggregate a query to produce the following: Workplace Avg M100 4.7 M120 3.45 Which would be a normal aggregate: SELECT Workplace, Avg(VALUE)

I would like to access a table in MS Access from a stored procedure on MS SQL 2000. The MS Access DB is running on a diferent computer attached on the same network. I think I need to create an ODBC connection from the MS SQL 2000 to the MS Access DB but not sure. Secondly how do I refer to the table in the MS SQL stored proc? Thanks for...

On a huge Sql-Server 7 installation, we have various client applications distributed along the Lan, accessing one main database. Each application accesses the db using one out of around ten logins. Most of them, have only DBDataReader right on the db, as they are consultation consolles only. In order to monitor db usage, the customer...

how can i merge MS Sql Server 2000 esktop engine deployment with my application setup program.

I have MSDE installed on my sistem, and I need to add a new user. How do I go about doing this?

Hi, Every day we perform a full database backup. (during the night). Since we need no "additional" backups we had the problem that the transaction log file grows and grows. Therefore now just after the backup we perform a backup of the transaction log with no log. So we free up the space in the log file. (it truncates).

Hi, Is there an easy way to determine the rate of change for table? I realize that I could do periodic select count(*) from XXX, but that would only determine the size of the table. It would ignore updates. What I'd really like to do would be able to determine the number of non-read operations over a table so that I can determine the...

Hello, I'm using DTS to update a SQL database with data from an ODBC Database. The update is going fine for most of the data, but not for decimal fields. I get an error about datatype number_.. Probably i have to choose another datatype, but none of them works. How can match the datatype of the field in the source database with the one...

hi, guys i have query which given below output given below manager personlevel person name 2085 1 Howard Wilson1 2085 2 Howard Wilson2 2085 3 Howard Wilson3 2085 4 Howard Wilson4 2085 5 Howard Wilson5

I have a distributed inventory control database that I am going to migrate from Access to SQL Server. I am going to use SQL Server Replication to keep the data current. There will one SQL Server 2000 database at HeadOffice, and about 200 branches will each have MSDE 2000. For tables that are the same for each branch (e.g. StockItems,...

I have a distributed inventory control database that I am going to migrate from Access to SQL Server. I am going to use SQL Server Replication to keep the data current. There will one SQL Server 2000 database at HeadOffice, and about 200 branches will each have MSDE 2000. For tables that are the same for each branch (e.g. StockItems,...

I have an environment that has 18 separate SQL server machines. When connected to the LAN I can connect to each and expand the databases tab no problem. When I try the same over a VPN I find that three of my servers will connect but on expanding the databases I get a long pause then 'No items'. I've checked around and found some references to...

Folks, I have the following data in a table: 4 NULL NULL 2 abc NULL 2 aaa NULL 4 xyz NULL 4 xyz pqr 4 pyz xqr