Databases Forum

How to check the duplicate Columns in a table

Lets say I have 1 department which have 4 suppliers supplies 4 different types of product (A,B,C,D) my main objective is to capture rating( 20 types) of these different types of product in alphabet and also in numerical thru lookup table I created following tables Supplier( supplierid, supplier) 01 ABC …

Good day all! Need assistance with the following: I a table that houses information and want to create calculations based on the info. I have created a view to perform one of the calcs. Now I want to sum columns that will put info into another field that I can …

Hi all Just a quick question from a noobie! If i have a DB mirrored...if I apply schema changes to a table in the primary mirror db...will the secondary mirror DB get updated? or is it just data that get's mirrored? Thanks in advance

I would like to add a field from a table to an existing view without changing the structure of the existing. Below is the statement for the existing view and the result [CODE]SELECT (SELECT COUNT(*) AS Expr1 FROM dbo.BillsSections WHERE (BillIndex = a.BillIndex) AND (Type <> 7) AND (BillSectionIndex > …

Good day :) <<== new, please excuse If I post shit :) I've one query which doesn't work: [CODE] SELECT conquer.timestamp AS time, conquer.new_owner AS new_owner_id FROM de12_conquer AS conquer INNER JOIN de12_tribe AS conqueror ON conqueror.id=conquer.new_owner INNER JOIN de12_tribe AS loser ON loser.id=conquer.old_owner WHERE (conquer.timestamp>0 && conquer.timestamp<1213647029734) AND (conqueror.ally=37038 …

Hi, the Microsoft SQL Server version is 2000 Basically I want use a basic regular expression but can't seem to get the syntax right. i want to compare ID_short = ID_Long ID_short is a truncated version of ID_Long, and I want to search on the beginning only (hence I can't …

please help for MsSQL stored procedure for ASP.net/C#. Inside stored procedure i used 4 different statements in where clause . first one is working but last 3's are not . Statements are given below- FILENAME LIKE ''%'+ @FILENAMETEXT +'%'' FILENAME LIKE '+ @FILENAMETEXT +'%'' SUBSTRING(FILENAME,1,4)='+@FILENAMETEXT+' LEFT(FILENAME,4)='+@FILENAMETEXT+' bunch of code for …

Hi guys, How can i convert code below into INNER JOIN style. Thanks [code] UPDATE def_1 SET Valid = 'Yes' WHERE id IN (SELECT id FROM def_2) AND paid IN (SELECT paid FROM def_2) AND valid IS NULL [/code]

Hi, [code] INSERT INTO table1 (supid, paid) VALUES ( (SELECT supid FROM def_1 WHERE id IN (SELECT id FROM def_2)), (SELECT paid FROM def_1 WHERE id IN (SELECT id FROM def_2)) [/code] This code returns more than 1 value, teherefore i can not execute it. Is there any other way …

Hi all, I'm trying to design a database model for some ancient poetry books. Here are more information: - Each verse of book will be a recorded into database. This is critically important since I need to have different feature for each verse. For example, being able to put comment …

Hi, [code]select id, pay from def_1 where id = (select id from def_2) and pay = (select pay from def_2)[/code] This generates an error "Subquery returns more than 1 rows". Where is mistake? Thanks

Hi All, Here is my question. Is this SQL Compact Edition 3.1 free to Develop,use and distribute it with my application? I have two SQL Compact Edition: One from : [url]http://www.microsoft.com/downloads/details.aspx?familyid=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en[/url] And another from : [url]http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en[/url] Help me which one to use and which is free as mentioned above as …

Hi all, We're implementing a web-based database application for keeping track of employee emergency information. I need a sql query to select a row, but leave out any fields that are empty (but not null). I've got it working so that all fields in a row are selected. The problem …

im Indian a novice and in php. I installed the wamp server2 that has the apacheserver,phpmyadmin and mysql but when I try to connect mysql through PHP code a error message - "Warning : Mysql_connect()[function.mysql.connect]; Access denied for user ' '@'localhost'(using password YES) in c:\wamp\www\school\temp.php on line 10." is comming …

Greetings Daniweb! I am building a webapp business management system. The backend that supports the app is currently under design and I am wondering on the following: In reality, each business' records have nothing to do with another business' records. I would like to design my db to reflect this …

I have a JSP that works with an Oracle 9i database. On my local windows workstation (using Tomcat) where I developed the JSP the application processes very quickly working with the Oracle database. The JSP application on the Production Intranet web server (Tomcat) connecting to the same Schema processes very …

I would like to SUM two fileds from different rows from the same table but I don't know how to do that. E.g. BillingTransactionsIndex CreateDate UserType UserIndex TransType Reference Total Balance 2 6/5/2008 15:02 1 51 1 150 -288.2 -288.2 5 6/8/2008 11:55 1 51 1 157 -1.58674 -289.787 In …

Hello everyone I am building on a little project in .net, but I have ran into some problems on database - level. I am creating a view with data from a couple of tables. It all revolves around my main table (let's call it 'main' for now). In 'Main' there …

As a beginner, after creating tables, what is the next step?

O-kay, so i'm trying to get a simple data flow diagram of a customer making a hotel reservation. so in short : i need a Data flow diagram of a hotel reservation system. could anyone please provide me with one? thanx alot

I have 2 tables: an IP Address table, and an IP Ranges table. I want to retrieve a list of ranges in the ranges table for which one or more of the IP addresses in the IP address table fall within that range. The IP addresses are represented as integers, …

Hi, I have created an Access 2003 database for about 20 users over a network. I am currently weighing options as to just have the database on the network or to split it. The one main question I have is how to distribute design changes and possibly table design changes …

Hi all, I have a problem with a query in access that I cant seem to figure out. I have a form named frmRecruitment with a subform named sfrmParticipant. At the moment I am using an append query to append records from 'sfrmParticipant' to 'frmIntervention' using a button on a …

Hi friends, I think the MySql is not case sensitive for selecting values. for example I am having a table called dept, Id | Depart 1 | BTECH 11 | it 12 | ibt 2 | BE 21 | cse 22 | ece Now i want to select the capital …

I was wondering if anyone out could help me with a problem I'm having. I have been asked at my job to set up a purchase order database and one of hte things they want is when a purchase order form is filled out, instead of the data going into …

Hello all, i have got an issue with a client here, who is running an internal CRM system. we need to get information into our Webserver (Linux-MySQL5) database (dealer lists, product lists, ....) and this information is stored in the CRM. but the CRM is Windows-MSsql. The output is .DAT …

How to write a procedure which takes integer N as its IN parameter and print a number series (up to N) in the Following format. 1 2 2 3 3 3 4 4 4 4 : - - - N N N N N…………N

Hi All, I apologias to everyone posting all these questions. I have a meeting on Monday afternoon to review the possibility of using FileMaker pro 9 as our database. Having said that, I need to setup a database in FMPRO 9 and present it as prototype for that meeting. So …

Hello all, I am wanting to structure a database that will allow for multiple prices per products. I also want to be able to upload an image and enter details about the product. My initial thought would be to have a product_db and have a price table, a product table, …

Hi I'm migrating from Oracle Sql to MS Sql. I'm trying to write an mssql query that will pull all rows from a tableA but only if row in tableB = apple. In other words the table might look like this: tableA tableB Joe apple Joe orange Joe peach Fred …

Hi, I am developing a hand held device. I am using .net compact frame work with WINCE support. Here i want to choose a open source database which supports WINCE. Can any one tell which open source database will support WINCE platform. Regards, Vijay Bhaskar

I'm sorry but I'm totally new on Web Development, I'd like to make a registration form for everyone that downloads a file I have on a Website. The ideal thing would be to send a confirmation email where the link to file is attatched. So basically when a person wants …

Hi I am new database designer. I am wondering if there is ready-made standard Nationality lookup table, I think I will find those entries in some txt file since Every DBMS can load a text file. and I think there must be a standard schema for that table something like …

Hi All, When I run the query: [B]select (100/50)[/B] It give me "2"... good. But when I run the query: [B]select (50/100)[/B] I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"?

can any one Suggest me a good E-BOOK for SQL server 2005??

Hi, I would like to know if there is a way to link to a sql table, but not be able to edit it, the table is part of another program data and I just want to look at data, maybe copy to spreadsheet. I figured out how to get …

Is there is query with which I can get the sum of elements in one row? I am trying to develop an atttendance application. Design as follows- <date1> <date2> <date3> <date4>--- <attended> <rollno1> 1 0 1 1 3 <rollno2> 0 0 1 1 2 <rollno3> 0 1 0 0 1 …

I need to create a query of records in one table along with a count of how often those records occur in 2 other tables and the difference between the counts.

hi I want to fetch data from four tables using a single query.please tell me how to do that. thanks in advance

Hi guys, Im working on a bit of MySQL and was wondering if there is a way (without using php arrays or other) to search a table for a value (say 1) and return the rows which '1' wasnt found in. != wont work because the table contains more than …

i have 2 tables : 1.Ms_Menu Menu_Id,Menu_Name 001 | Menu1 002 | Menu2 003 | Menu3 2.Tbl_User User_Id,User_Name,Menu_Id User1 |Name1 |001 User1 |Name2 |002 User2 |Name2 |002 i want to joined 2 tables using UNION(or other way if works is fine->left/right join) my coding : [code=sql] SELECT User_Id,User_Name,Menu_Id,'' Menu_Name FROM …

hi, i have two entities products and categories. both have many-to-many relation. how can i get the products that are not related with the categories. i mean the ones which not not mapped in junction table. thank you! daniyal nawaz

I'm looking for some guidance on how to develop a msql query that loops through elemenets in a php array. The array is constructed from a multiple line list box.

i am working on an ERP. there is a core database. and for reporting data we have replicated databases. i want to ask if any could share knowledge of how large database user applications like Yahoo mail or Orkut are Designed. more specifically, how DataBase is desinged for application like …

is it possible for a trigger to handles two tables ? my question, "Write a PL/SQL trigger that, on the insertion of a donation, will set its bloodGroup to the donor's blood group if the donationType is 'whole' or 'platelets', and null if the donationType is 'plasma'." and my trigger …

i need some help i wana talk about security in mysql 5.2.5 plz send me links (i searched mysql.com site and still i'm not able to get anything about mysql 5.2.5 , no informations were found) 10x

I am trying to create a sql statement like set @sql = 'select @stage1 = count(MY_ID) From VW_OPEN where ' + @filter and run it with exec (@sql) However this generates an error Must declare the variable '@stage1'. If I run statement select @stage1 = count(MY_ID) From VW_OPEN the var …

I need to write a query that will pull my products and price. However each of the products have multiple prices and I want the price with the most recent date. I have tried the following query but it doesn't work. Can someone assist me. I'm fairly new to sql …

Hi. I know this is MySQl forum, but maybe some one help me through the below issue: I don't know which file I should download to install postgreSQL, could nayone please guide me which I should download ??? [URL="http://www.postgresql.org/ftp/source/v8.3.1/"]http://www.postgresql.org/ftp/source/v8.3.1/[/URL] I am using Windows OS.