2,736 Topics
| |
Hi. I have just installed 2005 in my on my database server. Now, I have a web server and will need to access my database from my web server for simple stuff such as querying the database and checking tables, etc, etc. What should I be installing on the Web … | |
| I have a view that looks at new student records and a table that stores those records and information related to their Active Directory logins. What I need to do is filter out any duplicate records between the two "tables". So I only see unique records in the view to … |
My company is using a third party software designed by other private company. there is a point where there is data redundacny on our tables and it requires me to do the data cleaning. i thought it would be better to fix the incorrect field with the procedure with those … | |
Hi, i have 2 tables. i have 3 equal colomns in both. I want transfer all data from 1st table to another one. How can i do it? Thanks this doesn't work but something like this; insert into exam (e_score, l_name, s_id) values (dbo.assignment.e_score, dbo.assignment.l_name, dbo.assignment.s_id) | |
Hi, I am writing a small search engine. There are two tables. The first one holds the search engine main index, the second one is link table. I have the following query that retrieves results. I would like to sort the results by: dbo.OCCURS2(LOWER(:query),se_links.anchor). se_links.anchor obviously comes from se_links table, … | |
HI, [COLOR=#000000]I am trying to return automatic value into another column with using trigger in a table, when I enter new record into that table. It works if it is first data to be in that table. If I have more than one record already, it doesn’t work. I thing … | |
I have the following select query: [CODE]SELECT DISTINCT Job.JobID, Job.DateAdded FROM Job, ImageTag, Image, Tag, TagCat WHERE TagCat.TagCatID = Tag.TagCatID AND Tag.TagID = ImageTag.TagID AND ImageTag.JobID = Image.ImageID AND Image.JobID = Job.JobID AND ImageTag.TagID IN (#TagIDList#) ORDER BY Job.DateAdded DESC [/CODE] However, I need to add to the query the … | |
I have created the following stored procedure in sql server 2005.I m using asp.net with C# 2005. Can someone please rectify my errors why i m getting such type of the errors... [code] ALTER PROCEDURE CompanyStoredProcedure @uspcompanyid INT NULL, @uspcompanyname VARCHAR(20), @uspaddress1 VARCHAR(30), @frmErrorMessage AS VARCHAR(256) OUTPUT, @RETURNVALUE AS INT … | |
Hi, i'm new to all this. I'm really stuck!! I'm running XP Prof and have recently installed SQL Server 2000 Personal edition. It seems to have loaded in ok,,BUT,,it won't connect to my localhost,,i don't know what the problem is i get the 1069 error message. Pleaaaaasssee can someone help … | |
I want to install SQL Server agent using [B]Setup Factory 7[/B]. Can anyone please help me on how exactly I can do this? (I am installing a VB6 program that must access data from SQL Server 2000, so I want the setup to: 1. Install the SQL Server part. 2. … | |
hai guys, I am a newb in SQL server. yesterday i have installed microsoft sql server 2000 to my computer. But i don't know how to employ this. I have a group of ASP pages that contains my MBA assignment notes and files, and is successfully working with IIS in … | |
My dears, I have installed SQL server 2000 on my computer. And have made database through the below command: Create database mydb go exit But nothing happens. I don't know how to manage this database. Can anybody clarify how can i store my ASP pages in this database. How can … | |
I have three tables that are linked as follows: SOShipheader.shipperid, SOShipheader.invctot SOShipline.shipperid, SOShipline.invtid, SOSHipline.qty, SOShipline.price SOShipmisc.shipperid, SOShipmisc.miscid, SOShipmisc.charge Here is what I want the report to look like: S80709 150.00 abcpart 3 40.00 defpart 1 10.00 misca 20.00 S80710 30.00 defpart 1 20.00 miscb 10.00 I have group1 as soshipheader.shipperid … | |
Hai guys, i want to know how to create a database in sql server for creating a database in sql what should be download in my system. and how to download it .my system has windows xp proffessional. please tell me how or give some website name to know detail … | |
Forgive my ignorance, I am new to RDMS and SQL both. My question is this: I have 2 tables, one a primary table and 1 a relational table table 1 has ten rows valued 1,2,3,4,5,6,7,8,9,10 table 2 has 4 rows keying from table 1 row1 = 1 2 row2 = … | |
Hi All. I am now doing this tutorial step by step ; [URL]http://www.azroc.co.uk/csharp/asp_net/asp_net_data_access_layer2.htm[/URL] ----------------------------------------------------------------------------- It shows on how to create a dataset and retrieve it.Then it will be show in the browser.But then, when try to run, it says got error at my aspx.cs file. Well,I run the codes by … | |
Hello Everyone, I have a DTS package, which has been working fine for few years. it runs once a month to get information from different databases and save it into the destination database. Now I get this error: error source: microsoft ole db provider for sql server error description: could … | |
I'm having a problem querying data from two different databases on a SQL 2000 server. We have two databases, a main data db, and a separate security db that has login info. Database logins for the data db DO NOT have access to the security db. I have a function … | |
Query to find the 10th maximum salary from an employees table which contains empno,empname,empsal as columns.If this table contains n number of records,how to determine the 10th maximum salary | |
Hello everyone, This was posted in the PHP section also... I have a MSSQL [URL="http://www.daniweb.com/techtalkforums/thread70770.html#"]db[/URL] with PHP front end. The [URL="http://www.daniweb.com/techtalkforums/thread70770.html#"]data[/URL] in the table is similiar to: "Two spaces" with 2 white spaces in the middle. When I use this [URL="http://www.daniweb.com/techtalkforums/thread70770.html#"]code[/URL]: [code] $sql = "select Name FROM Name_TBL WHERE Number … | |
| OK, I'll admit straight away i'm new to SQL. I've got a SQL 7 Server with two small databases running. I have been able to backup both to file. However when I try and "restore" them on a test SQL 2005 Server, it errors because the file & folder structure … |
[COLOR=midnightblue] Hello All, Apologies if this is the wrong forum section. Some help and advice please regarding a [URL="http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19631#"]SQL[/URL] Report. It is for a Feedback form and below is a quick mock up of the DB diagram [IMG]http://img219.imageshack.us/img219/4102/feedbackbr8.jpg[/IMG] tblFeedback is populated with a [URL="http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19631#"]Customers[/URL] details and the tblResults with the … | |
Hi: I'm writing a VBA macro in xls to chart various records that I'm querying from MS SQL. One of the values that are most important for me to chart is the total number of records. The way I have the xls code, I can pull the data into xls … | |
Hello, I was looking around for some tutorials about how to backup my database in my hard disk using [B]SQL Server 2000 Enterprise Manager[/B]. Can someone explain me in a friendly and step-by-step method? (screenshots preferred) Thanx so much in advance | |
Hello... :eek: Sorry, I'm new here and new to SQL (please dont kill me for asking) What I'm trying to do is write a script to backup a few databases in SQL. I know that I can just right click on the db and back it up, but how is … | |
I am running a website of crossword puzzle and Sudoku games. The website is designed to be: [LIST=1] [*]There are 20-30 games onlines each day. [*]Every registered user could play and submit the game to win scores. [*]For each game, every registered user could get the score for ONLY one … | |
Hi Everybody How can I use 2 update stmts in a single SP? I want to update two tables, with different data, but with the same, where clause Is there any way to do that? thanks | |
i am trying to install the ms crm trail version and i keep getting err msg " The minimum required version is SQL Server 2000 SP4 (8.0.2026)." i already downloaded the sp4 with all its components updrade and my sql version is 8 but i need it to be 8.0.2026. … | |
[B]Intro[/B] I'm not the best at this, but I thought we were lacking a SQL tutorial... [B]Test table[/B] My Little Test Table called "test" for this great exercise contains the following [B]FirstName[/B] [B]LastName[/B] [B]EyeColor[/B] Paul Esson Brown John Smith Blue John Howard Green Kim Beazley Gray [B]SELECT[/B] This selects data … | |
I hava a table that stores payment information, with invoicenumber int and part varchar, where part can be (1/1, 1/2, 2/2, 1/3, 2/3, 3/3, etc) The thing is not all payments are related to invoices, so I have many null value for invoicenumber. Is it posible to create a UNIQUE … |
The End.