2,736 Topics
 | |
| | Hi. Can anyone help me with this? If I have, for example, a MSSQL database named 'COUNTRIES' and an existing table in the database named 'COMPANIES', can anyone let me know how I can add an additional field name 'PEOPLE' with a string datatype (for example) to this existing table … |
| | select convert(decimal(5,2),(7058/7482)*100 ,0) is showing .00 value in sql server 2000. Why ? How to retrive value with decimal part, plz. guide me. Thanks & Regards Girish  |
| | Hi guys, The question I need to answer is [quote]This query is about patients who got the same illness on the same day. For each pair of such patients, display one row showing the illness code, the date of onset, and the patient number of each person involved, e.g. FLU … |
| | hi everyone. I have a web application on ServerN that needs to access data from SQL Server 2000 db on ServerD over the Internet. However, for security purposes, ServerD is not allowed Internet access. Therefore, there is a ServerM on same LAN as ServerD. ServerM has Internet access; and can … |
| | dear to all, i want to make my database name as a dynamic one which i'll make it as as a parameter value in a stored procedure. pls help me of what the codes should be. any hint or something. i've tried: declare @data varchar(10) set @data = dbName USE …  |
| | There is a problem to connect to the server from a remote client through enterprise manager or query analyzer, the two systems ar in a netwok, but no domain is there. There is a connectivity between the computers but connection cant made through SQL Server error is connction refusedm, server … |
| | I have stored procedure in MS SQL and I want to deliver value from form (value of textbox) in MS ACCESS. CREATE PROCEDURE sp_DeleteOwing @OwingID int AS INSERT INTO Arhive SELECT MemberID, ArticalID, OwingDate, GETDATE() FROM Owings WHERE OwingsID = @OwingID DELETE Owings WHERE OwingsID = @OwingID GO I tryed … |
| | Hi all, I currently have a view in my database that pulls certain data from a table. The issue I run into is sometimes this table can be empty, and so I have an empty view. I have been unsuccessful at using an IF statement inside of my view. Is … |
| | I have two tables A and B. I want to update rows in Table A depending on the back up data stored in Table B. [code]Table A = most current table of data Table B = 5 day old back up of table A[/code] Structure of both Table A and … |
| | I have to write a view that will return all invoices, but with the contact person of the last invoice issued for the same product. It is hard to explain so I will try to show on example: Table1: "Invoice" Table2: "Invoice_row" Table3: "Contacts" Each Invoice record contains Contact_id field … |
| | Hi all, I now have four server SERVER A is acted as distribution server SERVER B, C is acted as publication server SERVER D is acted as subscription server A is located with same network segment with B and C. D is located with different network segment. Server B and …  |
| | hey i jsut have small question it might be silly but i am new to database and don`t know anything about SQL first is SQl the same thing as SQL server? second i have MS visual studio installed on my PC how can i start using SQL!!! like what is … |
| | Hello. I'll get to the point. I need to add new rows to table2 depending on the data found in table1. I've tried a small query I wrote up myself but I doubt it will work and can't risk screwing this database up. Note: These tables are extremely long, one … |
| | Hello. I'm running an client installer for a program which populates a database running in a MSSQL instance over the internet using a system DSN ODBC connection. The ODBC connection tests work but the installer fails at a certain point with the error "RPC server unavailable". I've posted this on … |
| | I am trying to come up with a SQL query that will read timestamps from a table cross-referenced with the groups and individuals. What I want is results for each person on any given day with the first and last (min/max) EventTime. With the tables below, for example, an entry … |
| | Hello All, first time post here and really stuck on this issue. I have 4 Tables that i am Joining Across. Each one of the tables has around 800,000 Rows in it. I am Joining them all on a field Called MDRReport Key. my query looks like this SELECT Mdrfoit.MDRReportKey, … |
| | how to write a query to insert a row that is deleted from one table to another table using sql server 2000 at the same time  |
| | Hi you wonderful helpers who generously give your time away to help the less competent :) I thought this would be an easy task but I'm not an advanced SQL guy and don't know how to use an inner join, which apparently I need to use. I have two tables … |
| | When i try to install MS SQL 2000 on Windows XP machine it says that server component is not supported by this OS.What should i do get it run on this machine? |
| | hi every one, i want to know about configuring sql mail.i have sql server on my computer and i want to configure it to send sql mail.i want to know which account i have to use as local system account is not being accepted.when i try to create seperate account,i … |
| | How can i copy Tables from mssql server from my computer to oder /from my server to oder/. The Data Bases are ready created i must put only the Tables to oder DB. Please can you tell me how? |
| | I am using VS 2005 to connect to my MS SQL server. I dont have remote access or anyother way of getting into the box. I am missing Object Explorer in the vs. I need this in order to set some contraints on the database. Is there a way to …  |
| | I am trying to do some constraints on a database. Since I dont have the object explorer option. What is the command line syntax for a constraint |
| | hi, does anybody know how to update garbled characters that are being stored in the database..i am storing vietnamese characters in my db and found out that it some characters are garbled appeared as ? or squares... any help is grately appreciated..thanks in advance.. :):) |
| | How do you check free space or space used within an MDF? The "Percent Log Used" performance condition alert doesn't check MDF files. The sp_spaceused is close, but combines all files, and sp_helpfile shows current file sizes and growth specs, but not free/used. How do you programatically get the same … |
| | Hi, Im having a nightmare trying to install SQL server Evaluation Version onto Windows XP Pro. In the installation, at the service accounts section, it just wouldnt recognise any of the Windows Accounts that are on my machine, therefore i using a Local System Account so i could come back … |
| | Hey everyone I want a where clause based off a variable input and I'm having some trouble with the syntax. My current code(incorrect) is below but it shows what I am aiming for. Does anyone have any suggestions? [CODE](CASE WHEN @inIndustry = 'ALL' THEN WHERE EXISTS (SELECT 1 FROM sysdba.C_PROJECTREVENUE … |
| | hi every one, iam a newbie in .net,i have a application in which i have to send email using triggers.can any one plz help, on how to configure sql mail .my application needs to delete rows on completion of expiry date and send the administrator email notifying it. ok waiting … |
| | am making a CMS solution and need help to get out an article list. The reason why this is a bit tricky is because articles does not have the same fields stored in one static article-table. In tblArticle all standard information about each article is stored. In tblArticleAttribute all different …  |
| | I need to write a query that pulls out Zip codes by the first three characters, so I started with this: [code] SELECT SUBSTRING(Zip, 1, 3) FROM AvailHomeZips AS tZip [/code] But I would also like to query out the zips by those substrings I pulled out, so that would … |
The End.