Which way of retrieving a record is more effecient?: Select tbl1.field1, tbl2.field1 from table1 tbl1 inner join table2 tbl2 on tbl1.id = tbl2.id where someid = somevalue and someid = somevalue or Select field1 = (Select field1 from tabl1 where someid = somevalue), field2 = (Selec...more >>

orange May 14, 5:16 pm show options Newsgroups: comp.databases.ms-access From: "orange" <orange...@mail.ru> - Find messages by this author Date: 14 May 2005 14:16:49 -0700 Local: Sat,May 14 2005 5:16 pm Subject: import complex data Reply | Reply to Author | Forward | Print | Individua...more >>

Every night i want to send the new records that are created from my remote client to my FTP site, using a application which sets up an internet connection on the client , exports the data to the flat file and downloads the flat file to an FTP site. Would anyone know how to do this? Thanks...more >>

How does one make a copy of a database (with the data) on the same server. Would like to do this to use the copy in a test environment. I looked at the Copy Database Wizard but the instructions in Books Online state that the database must be copied to another server and cannot be renamed using t...more >>

Hello everyone, I'm trying to solve this problem but can't seem to figure out how to start. I would like to create a rating system where people can vote (1-5 stars) on randomly displayed items. The randomly displayed items should either have very high ratings OR a very low number of ratings. ...more >>

Hello everyone, I am new to ERWIN and I need helps from the experts out there. We are using ERWin 4.1.2771 and have reversed engineered some MS SQL Server 2000 databases. The problem we are having is that we have a FK on a column to a table where the PK of the referencing table is on anothe...more >>

To get rid of redundant data in a table, my cleint will be providing something like this: IDtokeep Ids to delete 34 24,35,49 12 14,178,1457 54 32,65,68 I have to write a script for each of the above rows which looks like this: ----------------------------------- update ...more >>

I have a dynamic database that will be periodically queried to select the data from a blob field. This blob data field is text of a variable length. The data will be selected using an id field and a date range. There will be multiple blob fields returned that I would like to output into a txt ...more >>

I am using an image datatype to store multiple filetypes includeing plain text data. it works except for pdf Data. When I retrieve the the file couldn't be opened in acrobat reader and the file was 3KB bigger than the original. Any suggestions would be helpful. ...more >>

I've created two tables. One table (Classes) stores data about classes that we offer. The Classes table stores the class id (classid) and the max number of students allows (maxstudents). The other table (Students) stores student data and the class they register for. When a user registers for...more >>

SQL Server 2000 : I have a series of tables which all have the same structure. When any of these tables are modified I need to syncrhonise all of those modifications with one other table wich is a sort of merge of the individual tables with one extra column. For most of these tables this is n...more >>

I am able to run a query which runs FAst in QA but slow in the application.It takes about 16 m in QA but 1000 ms on the Application.What I wanted to know is why would the query take a long time in the application when it runs fast on SQL server? How should we try debugging it? Ajay ...more >>

I am not able to start the MSSQL Server service on my system ever since I shifted my house and got a new network provider. Earlier, I was on the local cable hub, now my computer is on a DSL network. I don't know if the network would have something to do with it, but I am just providing informati...more >>

How do i insert this string "23:58:44.000 UTC Wed May 11 2005" into the database with datetime data format... I tried using: insert into table (startime) values ('23:58:44.000 UTC Wed May 11 2005') but got Syntax error converting datetime from character string error. So how do i do it???...more >>

Greetings. Today I was testing the sql backup/restore functions on our primary server. I was able to backup my database without any problems but when I tried to restore it, I received an error "Could not find the index entry for RID '3610200101a03cc4b49d8bbc84bac50cbe042cecf76' in index page (...more >>

Dear All, I am new in MS Sql Server.I am facing a error "'PRIMARY' filegroup is full".I went through the all previous submitions.But still this error is coming.Please help me out. I have Installed Microsoft Sql Server 2000. It was working perfectly. Present Database Details =================...more >>

Hi all, I have a question about inserting records into sql server. I am brand new to sql server, always using oracle previously. Before today, I had always written statement such as this: INSERT INTO TABLE (COL1) VALUES SYSDATE; How is this accomplished in sql? I am using a datetime data ...more >>

This may be a stupid question but I can't find an easy answer for what I want to do. I need a blob data field that can store both binary and text data like the sql_variant field. I am using vb.net to populate a sql table. I want to store both string and binary data. ...more >>

I use Ftp to import a comma delim file. Problem: Day 1 file has 5 records. During the course of Day 1 ,users make changes to a field in the five records. Day 2 has same 5 records as they were at the beginning of Day 1(without changes made during Day 1) plus 1 new record. I need a stateme...more >>

I know this has been dealt with a lot, but I would still really appreciate help. Thanks. I am trying to transform this table YY--ID-Code-R1-R2-R3-R4...R40 2004-1-101--1--2-3-4 2004-2-101--2--3-4-2 ..=2E. 2005-99-103-4-3-2-1 Into a table where the new columns are the count for 4-3-2-1 for...more >>

I am running McAfee ePO and SQL Server 2000 on a dual Xeon 900Mhz box currently. It is slow. I am going to be ordering 2 new servers, 1 for ePO and 1 for SQL Server 2000. Anybody have any suggestions for the SQL Server's hardware specs. Thanks, Chris ...more >>

In T sql for sql server, what is the technical difference between the comparisons "is" and "=" for example: set @test = null print @test is null -> true print @test = null -> false ...more >>

What is the best way to setup relationships between one lookup table and many other tables. The tables did not have any lookup table relationships which I am adding. One lookup table is used for same data in several different places. To use one lookup tables with several tables, I had to disa...more >>

Can anyone help me troubleshoot this failed job. The error message in event viewer is: SQL Server Scheduled Job 'Job1' (0xB1D83B7357CF2B4C808AD1CFA34CE8F9) - Status: Failed - Invoked on: 2005-05-12 09:31:38 - Message: The job failed. The Job was invoked by User sa. The last step to run was st...more >>

Hi Having a little issue... is it possible to have multiple connections all get rolled back to the same point? I have a small database that seems to have been busy - but magically lost 5 hours of data (several 100k records...) This is across multiple databases. In one of them I do have a ...more >>

Hi, Does anyone know of a simple way to do this? I want to create an insert trigger for a table and if the record already exists based on some criteria, I want to update the table with the values that are passed in via the insert trigger without having to use all the 'set' statements for eac...more >>

Whats the best way to do the following? Field1 in Table1 contains numbers and characters seperated by # Examples: aaa#01, kjhkjhjh#21 and jlkjlkj#123 How can I create two new fields in Table1, one containing what is to the left of the # and the other what is to the right? Regards, Ciar=E...more >>

New to SQL and have a hopefully simple ??? I have a select statement that returns a date field in the yyyy-mm-dd hh:mm:ss format. I would like to find a way to strip off the hh:mm:ss portion and return the date only. Thanks for the assist ...more >>

I would like to create a job in Enterprise manager that runs sp_who2 and write the output to a file. The filename would need to be appended with a timestamp that makes the file unique. I can then write another job that will cleanup the directory by deleting files that are older than a specified ...more >>

Does anyone have any recommendations on how to solve the following? I would like to have a query that selects ALL columns from a database, however only records that have a count of a certain column which is greater than 1 when the results are grouped by a few columns. I know the following query...more >>

I have just installed Mysql on winXP. When I get to the mysql promt and type: create table mytable(id int); I get this error: ERROR 1046 <3D000>: No database selected It seems that I need to create a database first, but I was told this was not necessary to create a table, is this rig...more >>

Howdy all - I am *not* a DBA, so please bear with me. A client's Windows 2000 server went belly up yesterday afternoon after getting updates from Windows Update. Wouldn't come up at all any more. I broke the mirror for the OS, rebuilt the Windows 2000 installation, and installed MS-SQL 200...more >>

To all, I've got 3 questions on BCP and SQL Server 2K 1) actually is it BCP's functionalities == DTS under Enterprise Manager ? 2) I've tried to use bcp under isql (ie. the command prompt version in accessing the SQL server) but it just return an error like this 'Could not find stored proced...more >>

Hi all.. I'm trying to send multiple INT values to a Stored Procedure that will be handled in an IN statement. ASP Code: strSQL = "SP_Get_Selections '29, 32' where 29 and 32 are 2 integer values Now, in my stored procedure... I would like to look these values up in an IN statement lik...more >>

Say I use the following SQL statement to create a table CREATE TABLE BATCH ( BATCHNUM NUMERIC(5) NOT NULL, COMPID CHAR(2) NOT NULL, AMOUNT NUMERIC(9,2) NOT NULL, BDATE DATE NOT NULL, EDIREF CHAR(15), FLAG CHAR(1) NOT NULL ) What is the exactly different between these two select statement...more >>

Hello, I'm trying to decifer the data in the table that stores the data in the binary format. All numbers are placed in varbinary fields. All I know is the MS SQL 2000 database useing collation SQL_Latin1_General_CP1_CI_AS (default). For example the content of the field is: (0xB4F500000000...more >>

I need to get all rows that are between two dates. I need to look at the updated_date column and if it is null then look at the created_date column. I considered doing this with a function, but as I understand it, functions should be avoided in the WHERE clause. What else can I do to accomp...more >>

We are having a problem with XML in SQL Server 2000. When we run a stored procedure that uses FOR XML Explicit from the Query Analyzer, it returns the correct format : <HIT_SUMMARY><rank>1</rank><hits>1</hits><object_type_id>2</object_type_id><object_id>19</object_id><object_title>About Us</obje...more >>

SQL Server 2000 When joining tables, some use: AliasTableName.ColumnName = AliasTableName.Column while others use LEFT/RIGHT etc JOIN ....... Is one better than the other in cases where the join is a simple JOIN of equality ? Curious ... Thanks, Craig ...more >>

I have a table that I need to delete some data from and put the deleted data into a different table. How do I script the following. If Field1 in Table1 is null, remove that row from Table1 and put it in a new table called Table2 Regards, Ciar=E1n ...more >>

Hello, I would like to know if the equivalent Oracle rownum exist in SQLServer. Here is a sample SQL code to explain what I want to do : select jobs.name, jobs.job_id, jobs.description, hist.message, hist.step_name, hist.step_id, hist.run_status, hist.run_date, hist.run_time...more >>

When I run the code below, SELECT LEN(@mytext) prints 300 as expected. Yet SELECT @mytext only prints the first 256 characters. Isn't varchar supposed to have up to 8000? Is there something from the discrete math class I am forgetting here? Sorry, that was over 10 years ago. DECLARE @m...more >>

Hi there, I've done some searching around on this subject and can't find anything helpful or non-expensive so far. I need to export some tables from my companies Oracle server locally so I can work on a reporting tool which (hopefully) will speed some things up on our weekly report runs. I ...more >>

What is the definition of a theta join? I read that all joins with the comparison operators: =, <,> etc. are theta joins, but joins with = are called equijoins. How can a theta join both be equijoin and a theta join? ...more >>

Hi, does anyone kown if the final release or one of the next Betas of SQL-Server 2005 will support XQuery-Statemets including the LET-Feature. Thanks, Tobias...more >>

I have a stand alone Java application that uses MS SQL Server 2000 and Microsoft JDBC ODBC drivers to access it. Before I run the application, I open the task Manager to monitor the memory used by the SQL Server. Generally it begins 21 MB and very soon it reaches around 100 MB if I do some opera...more >>

Can someone recommend what SQL Database compare tool to use and why? Thank you ...more >>

On the latest SQL 6.5 with the latest SQL 6.5 service pack, what's the trick to creating an account besides sa that has the power to create databases? I was thinking of calling this account 'sa2'. Why do this? Well, my boss asked me to do it because of a SOX audit + SAS-70 audit kind of thing. ...more >>

hi i have a question how can i delete last added row. I have 2 tables . source and destination . I take a 1 row from source table , do some operation on it and save to destination table . after succesfull written I want to delete added row from source table.. i'm using a coursors. the main p...more >>

I would like to propagate an event signal to an external application when a table in my MSSql2000 server is updated. Prog A; I have an external application adding records to a table. Prog B; I have another external application using this table as well. When Prog A creates a new record in the...more >>

Hello everyone! I'd like to know which method is better for making a copy of an existing database in SQL Server 2000, restoring from a backup of the original, or using DTS to copy the objects to the new database. Any caveats or drawbacks to either method? I'm just trying to lay the groundwo...more >>

Hi, >From my vb.net application I want to test a connection to a server and a database, given a user name, password, server name and database name. What is the best way to test if the connection string is valid or not ? Would a connection to the Master DB be enough to say it is valid or not ? ...more >>

Dear All I have problem with my database server which running SQL server 2000. The server running very slow. The worst case, to save a record required more than 20-30 seconds. Since this problem, I usually monitoring Process Info from Enterprise Manager (Management - Current Activity), and I ...more >>

Received by email from LineVoltageHalogen [tropicalfruitdrops@yahoo.com] > I am trying to run a sql script via SQL-DMO. The script just rebuilds > some stored procs and I can get it to work, however it always runs against > the "master" database. Could you show me how to specify which data...more >>

Hi there I have an existing database in an SQL 2000 server and would like to relocate the transaction log file to another physical disk within the box. However, I am having trouble tracking down info on how to do this. If someone could let me know how to relocate the transaction log file, i...more >>

Hi- We've got an ASP.Net web app that runs off a Microsoft SQL Server 2000 backend. After a few days the SQL server is completely out of memory and crawls. It looks like there could be some connections that aren't being closed or something. Is there a good way to figure out where the prob...more >>

I have a pivot table implementation, part of which is posted below. It returns no errors in query analyzer, but when profiler is run, it shows that "Error 208" is happening. I looked that up in BOL and it means that an object doesn't exist. This block of code below works fine on my local develop...more >>

Is here an easy way to get 9:00 PM from 5/1/2005 9:00:00 PM without doing: Cast(DATEPART(HOUR,xDate) as varchar(2)) + ':' + Cast(DATEPART(MINUTE,xDate) as varchar(2)) lq ...more >>

After a trust with exchange server established the xp_SendMail gives the following error: xp_sendmail: failed with mail error 0x80070005 Prior to the trust everything worked fine. I have tried the following: 1)Checking SQL and SQLAgents accounts all match up with default mail profile. 2...more >>

Hi All, I have moved all my databases, logins, procedures from old server to a new one. When I try to send email from new server, I get the following error. Server: Msg 18035, Level 16, State 1, Line 0 xp_sendmail: Your SQL Server Service is running under the local system account. You ne...more >>

SQL Server 2000 SP3 on a Dell dual 2.4GHz Xeon box 3GB RAM Windows 2K SP4. Two aplication dbs, each less than 2GB in size. Had a problem where we would run Solomon queries and what not against the box. It had 2GB RAM, and sqlserv.exe would take up to 1.85GB of RAM, exhausting the physical RA...more >>

I am pulling several numbers from a SQL table, adding them and doing various calculaitons. The numbers do not display a comma to separate thousands. What is a way to format this? ...more >>

I am pulling numbers from a SQl Table and adding some together and doing other calculations. How do your format the numbers to insert a comma and show thousands? ...more >>

Hi, I am constructing a Message (Body) for sending our Emails. It is around 3000 characters long. But for whatever reason, the last line seems to be broken with a "!" exclamatory mark in it, which results in displaying the constructed image path as a broken one. How to resolve this ?. Thank...more >>

Dear group, I am a DB-Administrator for a Company that creates and maintains a software solution based on SQL-Server and Crystal-Reports. The Crystal-Reports part uses the following method to present data. First a specific user (database authentification) is created with a fixed password. T...more >>

Hi, anybody can help me. How can i synchronize 2 tables on 2 different sql servers 2000 i mean TABLE1(col1, col2, col3, col4) and TABLE1(col1, col2, col3, col4, col5, col6) the first 3 colums are the same in rwo tables. Thanks -- Message posted via http://www.sqlmons...more >>

I have tried getting this right from within an Access Grid but without success. My table looks like this: 12/24/2004 10:50:00 AM | CC | Level 2 | Heigle, Terry | 230 12/24/2004 3:00:00 PM | CC| Level 3 | Jost, Karen | 310 12/24/2004 7:00:00 PM | CC | Level 3 | Jost, Karen | 240 12/24/2004 10...more >>

Database is OK. I just need to roll back all the transactions until certain point in time. How to do it? ...more >>

DAK Is there a separate news group for SQLServer Replication. TIA Laurence Breeze ...more >>

When I start creating a new DTS Package and I choose the Analysis Processing Task icon, I only have the option of working with the local Microsoft Analysis Server. How can I choose a remote server's Analysis Server in order to process its database? Thank you ...more >>

Hi, would like to know how to write a crosstable select statment in sql server2000 where having: - ItemNumber, ItemDescription, ItemColor, ItemSize as rows - Stores as columns - Qty * Netttc as value from Table sales thx *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, would like to know how to write a crosstable select statment in sql server2000 where having: - ItemNumber, ItemDescription, ItemColor, ItemSize as rows - Stores as columns - Qty * Netttc as value from Table sales thx *** Sent via Developersdex http://www.developersdex.com ***...more >>

hello, i would like to know please if there's any mean to change delimeters (, or ;) and text qualifiers in a file in a i/o file written in vb ex: open #1 for ... write #1 ... thx *** Sent via Developersdex http://www.developersdex.com ***...more >>