When booting my Windows XP computer I get the message "SQL server is corrupt or has been ta,pered with". How do I solve this problem? Thanks, Don...more >>

Hi, I am new to MS SQL server. I installed the sql server 2000 evaluation edition on my PC( Windows XP Pro,SP 1). I can work with enterprise manager without any problem but I cannot open the SQL Query analyzer. When I click the query analyser ( either from start manu or from the tools box of e...more >>

Hello, I have a simple database of two tables, one table listing employees and the other a list of accidents. Whenever I add an accident the unique key is incremented by two when the 'Identity Increment' is set to one. Where may I look to try and solve this problem. Thank you kindly for an...more >>

Can anyone tell me where I can find the flag or setting that automatically converts an integer value to a varchar in an insert statement? e.g. Insert into mytable(CategoryID, ...) Values (1,....) Where CategoryID is a varchar(2) field. This fails with the message Server: Msg 245, Level ...more >>

I'm having a bit of difficulty adding Farsi in an SQL Server Table. when I try to insert Farsi into the cell, I get the infamous error: "The value you entered is not consistent with the data type or length of the column." I use MS Windows 2000 Advanced Server and MS SQL Server 2000 Ente...more >>

I am looking to select the top % from a subquery based on grouped values. For example, I want to select the top 10% of customers living in each state sorted by income in descending order. The only way I could think to do it was to put them in a temp table and run a separate query to appe...more >>

Hi everybody: I'm new in MSQL . I have programmed a backup task to make copy of master and another database each 12 hours. The problem is that when i did it i didn't ckecked the overwrite box, so the file increases everyday and i have to delete it. I have tried to program another backup job wi...more >>

i would like to install MS-SQL 7.0 and 2000 in my PC. I would like to know from which site can i be able to do so....more >>

How can we solve the error caused by dead lock?...more >>

when I query SELECT text FROM myTable, I only get a part of the data in that column returned. When I look directly into the table, I can see that there is more data there than I retrieved.. The column is a 1000 long text. How can I get all the data retrieved? obscurr...more >>

The following query contains a order header table and a modification table that keeps track of all changes made to the order header table. The modification table stores the date and time a mofication was made. Also, the modifcation table can have numerous records with the same order numb...more >>

I posted a question yesterday - pls see below - the only problem I have now is that there are several records for each order and I only want to receive one result per order so that I can get an accurate count of how many orders there are. Is there a way to only return one record per order ...more >>

Hello Everyone, I have a question & maybe someone can help. I have a query that looks something like this: DECLARE @VAR_A char(4) SET @VAR_A = ABCD select * from TABLE where TrSet = @VAR_A However, when I run it, I get an error message: Error: Invalid column name 'ABCD'. If I ...more >>

Hi All, I am trying to extract data from 2 tables. The problem is that Table A and Table B do not share a common field to reference on. However, Table A shares a common field with Table C and Table C shares a common field with Table B. Make and sense ....??? I have used the following s...more >>

Hi I want to select records where the amount of stock on hand is greater than the amount allocated and then to value it with the last cost on the last record in another table EG Cost Table Date Cost 10/11/2003 1.00 14/10/2003 3.00 15/11/2003 ...more >>

Hi, I am trying to install SQL Server 2000 Evaluation Edition Release A on my PC. I need this for practising Microsoft Content Management Server. I downloaded SQLEVAL.exe from Microsoft site. http://www.microsoft.com/downloads/details.aspx? FamilyId=D20BA6E1-F44C-4781-A6BB- F60E02DC1335&di...more >>

Hi, My objective is to write a report for surplus stock valued at an average cost. avgcost = (sum(QtyonHand * UnitCost))/sum(QtyOnHand) eg stockcode 1 Bin 1 cost = 3 Qty = 10 Bin 2 cost = 5 Qty = 20 bin 3 cost = 1 Qty = 30 AvgCost = (3 *10)+(5*20)+(1*30) / (10+20+30) = 2.67 surplus...more >>

hi I would like to create a query which returns 1 quarter of the results at a time... lik SELECT quarter 1 * FROM Tabl SELECT quarter 2 * FROM Tabl SELECT quarter 3 * FROM Tabl SELECT quarter 4 * FROM Tabl Is this something possible? How do I do it cheers Georges...more >>

Can anyone tell me how to add additional tables to a english query project. I have a simple project that reference 1 table now I want to add more tables. ...more >>

In my processes window I have a file called sqlservr.exe. It uses 104,600 K of memory. What is this file? Where did it come from? Do I need it? If not how do I get rid of it? thanks...more >>

I want See tables list in queru analyzer i forget command send me fast...more >>

How can i resolve this: The column prefix 'GR1_01_uniek.rd_gr1_01' does not match with a table name or alias name used in the query. Greetings, Ezekiel...more >>

Microsoft Consumer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three new vulnerabilities. Install now to continue keepin...more >>

Hi I have the following: case when ROP.splitstatus = '3' then 'M/c Stopped' when RRA.resid is null then '' else '' end as ActRes, but this is not quite right what I want is If ROP.splitstatus = '3' then if RRA.resid is null then 'Machine Stopped' else '' How can I achieve this? ...more >>

Microsoft User this is the latest version of security update, the "July 1999, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to protect your computer from these vulnerabilities, the mos...more >>

Is it possible to run with a SQL Server 7.0 on a Windows 2003 Server PC ?...more >>

In Access it was easy for me to retrieve data in any format by including the Format function in my sql. For example to Return a number padded with leading zeros where the number could be anywhere from 1 to 3 digits long, I would do the following: SELECT Format(fieldNum,"000") AS PaddedNum...more >>

Is there any function in SQL who can check if a date is valid??? For example: 2003-12-31 is valid and 2003-11-31 is not. Thank you for helping me...more >>

Anyone could give me an idea, how can I change the French SQL server Date format to accept American Date format? I have installed a SQL French version and need to get query based on USA Date version and it messed up. I want to send query in MM-DD--YYYY but this French version send ...more >>

Does anyone know of a website/newsgroup/any way or means of keeping informed of exactly when new service packs and hotfixes come out for SQL Server? Especially after the Slammer virus i try and keep our server completely up to date, but this is difficult because i need to search the inter...more >>

Microsoft Customer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to he...more >>

I'm having a very frustrating time trying to display the quotient of x / y in my SELECT statement. If the result is > 1, it displays everything to the left of the decimal. If the result is < 1, it displays a 0. SELECT CAST(1/2 AS decimal(5,2)) AS MatchRate The result of this operation i...more >>

All, I have MS SQL 6.5 Database. One of the tables is an audit table with a date time column called time_stamp. When I display the values for this column the data time is shown as : e.g. 'Nov 03 2003 9:42AM' If try and select the values for this row as Select * from trial_audit where ti...more >>

I want to send a mail without the involvement of SMTP from a stored procedure in sql server. Basically a specific table will be read, records count will be extracted and emailed to a hardcoded email address. Please tell how i can go about it. ...more >>

Is there a way to create/update a connection scope variable that I could reference from a trigger? I have been using SUSER_SNAME() in a trigger that writes field level audit records. Previously, I have been using NT authentication to connect to the server, so the audit records reflected ...more >>

Will having a period in a login name create a invalid character error when adding name to database? Example; previous login names that worked - navsea_jonesrb name that will not work - navsea_ronald.jones...more >>