I have a strange problem.. The following update query is not working update userinfo set userstatus=0 where enddt is not null and enddt<getdate() and it gives me the following error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >,...more >>

Has anyone used a migration tool to move an Oracle environment to an equivalent SQLserver environment? Thanks. Stephen ...more >>

How can I split the numbers to thousand digits in SQL 2000? SALES (FLOAT) SELECT SALES FROM TOTALSALES Result: ---------------------- 416455455445.0 855855555.0 I need to see the result like this: ----------------------- 416,455,455,445.0 855,855,555.0 Thanks,...more >>

Can anyone please give me a categoric answer to the following questions please... 1. Does SQL Server 7.0 run on a windows 2000 server and if not are there patches to be applied to make it work? 2. Is there a difference between US and UK versions of the software? Thanks in advance...more >>

I am trying to run a query like the following: set rowcount 5 Select distinct col0 from tab0 where date between 'date1' and 'date2' sort by count(instances of returns in select statement) While this is a little oversimplified, I am trying to select all distinct rows, sort them by most to ...more >>

From an earlier post, I was informed one way to find a common set of values in a table is with a self join. Here is a query I constructed with many self joins: select distinct a1.report_byperiod from #Acct_info a1, #Acct_info a2, #Acct_info a3, #Acct_info a4, #Acct_info a5, #Acct_info a...more >>

The problem is I have a table called Products and a table called Order_Items. Customers can place many orders so what I want to do is for one particualar order show all Products but link to Order_Items on a left join so that for ordered. The problem is when I filter out for the Order I wa...more >>

I'm having trouble figuring out the proper SQL statement to use for this. Any help would be greatly appreciated: Three tables are involved. Example data: Table: Products lngID strProduct 1 Toy 2 Book 3 Fruit 4 CD 5 Game Table: Groups lngID strGroup 1 Sales ...more >>

Hello, Anyone know how to retrieve SP version info in SQL 2000? thank you in advance. bernard...more >>

Hi, Can i use MS SQL 7.0 on Windows XP O/S to access data/communicate with DB on the Hosting providers Server? or is MS SQL 7.0 only compatible with Windows NT. Do you know where I can find a Trial Version of MS SQL 7.0? Can anybody help me... Thanks a lot Derek...more >>

I am trying to output the results of a SQL query (Server 2000) to a text file that can be sent to an internal web page. I can view the resulting data in a view via Enterprise Manager, but cannot figure out to output file. Thanks....more >>

I need some help knowing where to start of a query. I have a set of records. Each record has an account number and a period. I am interested in a particular set of account numbers such as acct number 1 and acct number 2. For that particular set of account numbers I need to find the lis...more >>

Hello, I could not construct an SQL query that would return an Entry of maximum date per Trailer Number, it still returned more than one of the same Trailer Number where the Status number was different. So I have used the return data from one query to feed into another. However, I also wan...more >>

Hi Does any body know a sql statement that would retrieve the table names within a database. Kindly note that I just want to retrieve the list of the tables within a database... Thanks Jamie Waters.. ...more >>

Hi Does any body know a sql statement that would retrieve the table names within a database. Kindly note that I just want to retrieve the list of the tables within a database... Thanks Jamie Waters.. ...more >>

I have a table that has a duplicate of each row. I would like to delete one of the two duplicates out of my table. I can find the duplicates, but I need the query statement to delete only one of the two. thanks Brian...more >>

Hi!! I desperately need help! When I upload the following code to the server of my provider I receive an unclear error message. I don't have any idea what I am doing wrong. This is the code: SELECT * FROM DB1 WHERE merk = 'Example' UNION ALL SELECT * FROM DB2 WHERE merk = 'Example' T...more >>

I am trying to get a record to write to my table even if the selection criteria fails. I need the columns to be in my table even if they are blank. Any suggestions?...more >>

I have a table with 5 million records. The table has two columns - firstname and lastname. During a design change, i am adding a new column say FullName. I dont prefer to update the entire table using a SQL query. Instead, is there a simple way of defaulting values in the column as su...more >>

Hi all, I need help with using the xp_deletemail command. I have a sql script/statement that will get the contents of the email(s) in the mailboz and inserting them into a database. Thsi bit works fine but I would like the emails to be deleted once they have been inserted in to the table...more >>

Can I use a wildcard in my query, lets say I have few entries in the table starting with "wonder01,wonder02...wonderxx..) also how about the date what if i want to find all the record entered in july this year only? how do i go about it. Thank you...more >>

Hi Everyone, I'm struggling with the below query. If I leave out the "order by" clause, the query runs in less than 2 seconds. However, if I include the "order by" clause, it takes almost 60 seconds. I've used the index analysis tool and queried the knowledge. I can't seem to find a...more >>

Hello Everybody I have installed notification services of SQL SERVER. I want to use these services to send email when a record gets added in the database. I am very much new to this technology.Can anybody help me in this regard by sending me some good tutorials or step by step instruction...more >>

I want to update the last row in a table. How do I do it? Thanks in advance...more >>

Hi: I need a query to truncate values, e.g. I want to truncate the value 12345-4321 in a varchar(10) column to 12345. I do not want to change the column def'n. to a length of 5. Thank you......more >>

Hi, I have a database that includes the following tables 1) Stock_Details (Stores Stock Description, ReOrder_Level, ReOrderQuantity etc). It does not store Quantities 2) Stock_Locations (Table records movements in Stock and to what location) So in Order to calculate quantities in sto...more >>

Hi, I have a database that includes the following tables 1) Stock_Details (Stores Stock Description, ReOrder_Level, ReOrderQuantity etc). It does not store Quantities 2) Stock_Locations (Table records movements in Stock and to what location) So in Order to calculate quantities in sto...more >>

I am using SQL Server 2000 Query analyser to gather some data from a database. I have the following: SELECT CAST(var1 + 'D' as CHAR(30) FROM tblName and assuming var1=ABC, I get the result: ABC D because there are trailing spaces in the var1 db field. Does anyone know how I ...more >>

to sum the cost of unique items... I have two tables A and B Table A is a list of unique items we sell and table B stores each item every time it is purchased and the cost... in table B there is a ITEM column and a COST column, so basically I want sum the cost for each unique item in the...more >>

Hi, I have exactly the same problem with Kalpakavalli, and is now getting confused with "collation" and "nvarchar datatype". Refer to post : Topic : mutilingual support and storage of unicode data in sql server Topic Starter : Kalpakavalli Forum : microsoft.public.sqlserver.mseq Could...more >>

Hi I have the following tables TranDetails (3rd Party) with 4 fields making up primary key Supplier char 7 GRN char 7 Journal decimal JournalEntry decimal detail1 detail1 detail3 InvMove Journal (PK) decimal JournalEntry (PK) decimal Stockcode char Supplier char Date date GR...more >>

I have a table with two duplicate records. I want to delete one out of these two. These two records are identical, so I cannot give any unique WHERE condition. Is there any way I can delete only one record?...more >>