7,494 Archived Topics
Remove Filter  | |
| | Hi, It's took me a weeks to figure out this query. I'm trying to select all the data from 7 tables but i got empty result. All these table has a link on region_id column. Your help will be much much appreciated. here's my query: [code]$q = 'SELECT rs.*,rr.*,cs.*,cr.*,cl.*,ls.*,ll.* FROM … Databases mysql |
| | hi friends i hava two primary key in single table no auto incriment.when i insert the value in jsp i getting like this error. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '0-3' for key 1 Databases mysql |
| | I want to get list of top 10 students (based on marks) in class.How can I write SQL query for it? Databases microsoft-access sql |
 | hi i need to store data more than 8000 char in varchar in sql server 2000 how can i? plz help. Databases mssql  |
| | Hello all: I'm currently building a website for a radio station and I want to setup a programming lineup. The fields I'm using are: ID Title Dayofweek (Show Day) Timeslot (Show Time) AMPM (AM or PM) Description Name (Host Name) Bio (Host Bio) Photo (Host Photo) I set these all … Databases mysql |
| | Hello friends, when iam working on mysql server 4.1 the power suddenly went off. and when i restarted the mysql the mysql service is not starting and the error [B]"#2003 - The server is not responding"[/B] is comming can any one please help me to get back the database please. … Databases mysql |
| | i am trying to set up this db and i am getting a parse error which it says it is on line 24 i cannot see the error. help need [CODE]$sql="CREATE TABLE IF NOT EXISTS `merc_users` ( `****` int not null, `******` varchar (250) not null, `*****` varchar(250) not null, … Databases mysql  |
| | Hopefully this will be an easy one for someone. I am trying to write a SELECT statement that pulls the row with the least time for each Special Number. Example data would be: Time Special Number 3:25:00 1 3:26:00 1 3:25:30 2 3:26:30 2 The expected output would be: 3:25:00 … Databases mssql  |
| | I have 2 table in a ms sql database prod_curs_test and rebuturi_test. I want to update some fields in prod_curs_test with data from rebuturi_test. I used this to do that: [code] update dbo.prod_curs_test set dbo.prod_curs_test.cant_rebuturi = (SELECT dbo.rebuturi_test.Cantitate FROM dbo.rebuturi_test CROSS JOIN dbo.prod_curs_test WHERE dbo.rebuturi_test.Comanda = dbo.prod_curs_test.Comanda) where exists (SELECT … Databases mssql |
| | Hi , I have designed a database that is to create a application simlar to microsoft money The database erd is aattched with this post. The database has following table Invoice Amount Account Profit_center Customer A invoice can sometimes split in to 3 parts therefore i have create table invoice … Databases database-design mssql |
| | Hello, I recently bought a new server and I'm trying to move the MSSQL database from the old mssql (MSSQL 2000) to the new system MSSQL Express 2005. I made a .bak file in the old server and restored it succesfuly in the new server. the thing is that it … Databases mssql web-server |
| | Hi! so I am trying to design a relational database and I think I am on the right track, but I am a little confused as to how I will actually update the data... Normally I build a flat file table and use a web form to add/update/delete data, however, … Databases database-design web-design |
| | [B]Is it possible in a query to delete a row specifying its row index?[/B] I want to delete a row from my table. I'm trying to figure this because when I delete rows from my datagridview, it does not update. So I was thinking if I just directly delete it … Databases mssql |
| | Im looking for a good access VBA book. Im advanced in access but completely new to VBA but have done other programming languages like c, c++, java, php and a few others Any recommendations greatly appreciated Thanks Databases microsoft-access |
| | hi friend I want insert value to three table in single query any body have idea pls send the query for me advance thanks by san.. Databases mysql  |
| | |
| | I am trying to crate a web application for a database (a form and a search+results pages). HOWEVER, I am seriously stuck because I cannot install IIS on my workstation to start working. The university I am at cannot have me IIS installed (it's forbidden) because it would turn my … Databases microsoft-access web-server |
| | Hello I seem to be having a problem, I have this query that pulls back correct results [CODE]SELECT hourStamp, SUM(CASE WHEN datestamp < GETDATE() THEN 1 ELSE 0 END) / @numberofdays as HourAverage, SUM(CASE WHEN dateStamp BETWEEN DATEADD(d,DATEDIFF(d,0,GETDATE()),0) AND GETDATE() THEN 1 ELSE 0 END) as HourToday FROM webstats GROUP … Databases mssql |
 | How can you make a table from a union query in access - i have the union working and producing what i want but i can store it as a view or as a table - i keep getting syntax errors [code] INSERT INTO HgTotals SELECT CollectionDate,HgTotalnglA as AllHGtotal FROM … Databases microsoft-access |
| | hello, I try the following query: [code=mysql] SELECT IF TIME(hour_end) > '21:00:00' THEN timediff(time(hour_end),'21:00') AS diff ENDIF FROM `hours` [/code] Why whould this not work? Any help would be appreciated. Databases mysql |
| | Hey guys, I have some question about a query in SQL I'm buliding for my software. This software meant for Bills managing. I have main screen which display all the bills and another screen which display the bill details, this screen built on 3 tables : Bill,BillItem,Payment tables. My question … |
| | I'm getting the error Incorrect syntax near '=' when running the following query. I'm fairly new to SQL, but this looks like it's pretty straightforward. Basically, I have a table with smartphone information (A_INV_SMARTPHONE) and a table for Windows CE Pocket PC information (A_INV_WINDOWS_CE). Both tables contain columns for Manufacturer … Databases mssql smartphone |
| | Hi all, I have a problem achieving the result. I want data as below which is based on 4 tables [B]Expected rasult [/B] SiteID SiteName State PostCode Phone1 StateName CanDelete --------------------------------------------------------------------------------- 1 Site1 1 2134 124 123 - ADC 1 2 Site2 3 2323 124 234 - QTY 0 3 … Databases mssql |
| | |
| | Hi Please tell me if you know a dis-advantage of auto-incerment PK Thanks Databases |
| | I have been trying to figure this out, surf thru google but I came back empty handed... I wana move data from Database A to Database B that means copying the content of one database to another database, I am using SQL server 2005... any help will be highly appreciated Databases |
| | Hi Guys, This is my problem: In the below table: donor receptor 1 -> 4 2 -> 5 4 -> 6 The above reads as follows... Student 1 donates all of his/her money to Student 4 Student 2 donates all of his/her money to Student 5 Student 4 donates all … Databases mysql |
| | I am using Access97 and have created an employee database. I am having trouble creating a method in which to get a new number for an employee and open a form in add mode with the new number already populated and then remove that number from the list of available … Databases finance |
| | Hey guys, I'm new here and actually new to access 2003. I have deal with Vb.net but never access. I actually doing a intern and they want me to build a huge database. All there documents are spread out and all over the place as format of excel. I could … Databases microsoft-access vb.net |
| | Hi I like to know haw doI create a form based on multiple tables, all tables are linked. Some table contains drop down lists, I want all info in all tables dispalyed in the form. Help Please Databases microsoft-access |
| | Hi, I am working in a finance project where each transaction table is having more than 4 Million records just for 3 months. I have user & branch related information on other tables. I wrote a joined query by joining around 5 tables to summarize the report based on Branch, … |
| | Hi I have Client, Owner, and Staff entity, they all are persones!! with additional criteria... Client ID, FName, MName, LName Owner ID, FName, MName, LName Staff ID, FName, MName, LName so Is there a concept of inheritance in RDBMS like SQL-Server-2005 if so how can I implement it. At lease … Databases client-server |
 | Hi all Is it at all possible to do this? I have a number of records that I need to recover. Any help would be greatly appreciated Databases mysql |
| | Hi, I need a clue on how to design a Many to Many relational database. For example, I have a products table and a supplier table. each product can be supplied by many suppliers each supplier can supply many products how can I orgranise this data in the tables? I'm … Databases database-design |
| | I am currently testing replication on mysql 5.0.9 running on Win XP Pro on 2 servers , one as a master , and another as slave , basic master-slave configuration. The slave have 2.5 GigaB of RAM,300GB SATA2 HD & on Intel 2.4ghz Core Duo and the master have 1 … Databases mysql |
| | I created a form in Access. I would like to put up the form on our website so people can enter their information. We need to review the data before they get into our database. I am actually stuck about how to publish the form. I thought it was an … Databases microsoft-access |
| | I am trying a multi select query in management studio and I am only expecting a result that is a single output per row, however, when I tried executing it. The rows I called repeated once. For example I have 2 rows in my column1 and when I multi-selected my … Databases mssql |
| | I'm currently working on a little project for a friend of mine. He runs a computer shop and needs a small application to register sales and print out a sales ticket. I've done this in Open Office and it works fine (hey, stop throwing things at me!). The problem is … Databases database-design |
| | Hey guys I have a table, that lists people, with a correpsonding date and time for each activity. My structure is like: PersonID......Date............Time 872367.........01/01/08......15:00:00 872367.........01/01/08......16:00:00 872367.........01/01/08......18:00:00 976737.........01/01/08......19:00:00 976737.........02/01/08......16:00:00 911967.........03/01/08......18:00:00 I want to have a query that returns each persons latest activity date and time, so I want a table like: … Databases data-structure oracle |
| | I am a new convert to MySQL. It sounds like an answer to my prayers, BUT when I look for some training I find the cost to be substantial. I have purchased a book Beginning MYSQL by WROX but I now realize that I need some more structured training. I … Databases mysql  |
| | hai friend's i am beginner in MS sql db . so can any one explain me detail about Foreign key and primary key , please give example also , thank;s in advance..... Databases mssql |
| | Hello, I try with the following query to calculate the working time of employees: [code=mysql] SELECT TIME_FORMAT( ADDTIME( TIMEDIFF(TIMEDIFF(hour_end, hour_begin),(hour_pause)), TIMEDIFF(TIMEDIFF(hour_end_o, hour_begin_o),(hour_pause_o)) ) ,'%H:%i' ) AS total FROM hour [/code] This works correct, if the pause is filled, if no pause is given, no total is displayed (NULL). How can … Databases mysql |
| | Whats wrong with this query? [code=mysql] TIME_FORMAT( DATE_ADD ( TIMEDIFF(TIMEDIFF(u.hour_end, u.hour_begin),(u.hour_pauze)), TIMEDIFF(TIMEDIFF(u.hour_end_o, u.hour_begin_o),(u.hour_pauze_o)) ) ,'%H:%i') AS total, [/code] I get the error: [QUOTE]#1305 - FUNCTION system.DATE_ADD does not exist [/QUOTE] BTW: I am using version 5.0.51a. Databases mysql |
| | Does anyone know how i can get a list of the java stored procedures that are inside the oracle database using oracle sql developer? If anyone has used Toad, i m referring to the list of java classes that comes up when u click the Java tab in Toad. Thanx. |
| | Hi there, I have a master detail set of tables with a one-to-many relationship. Let's call the tables Projects (master) and Markets (details). I need to allow users to query the database and be able to select projects by markets. In other words, users should be able to "say": "List … Databases mssql |
| | I have a MSSQL table that contains lots of duplicate records, is there a simple way to keep only one and remove all other duplicates? [CODE] mike M 60 mike M 60 mike M 60 [/CODE] I need only one record [CODE] mike M 60 [/CODE] Databases mssql  |
| | Hi, I couldn't get this to work, but I was using a PHP script to go through the rows in a table in my database and if it found a specific value, to delete that row. However, it deletes ALL the rows no matter what I do and throws an … Databases mysql |
| | Hey guys I have a current query that looks something like: [CODE]select a.avalue, b.bvalue, c.cvalue from (select idVal, dummyVal as avalue from....) as a left join (select idVal, dummyVal as bvalue from....) as b on a.idVal = b.idVal left join (select idVal, dummyVal as cvalue from....) as c on b.idVal … Databases oracle |
| | Not being a SQL programmer please forgive the following but I need to know. I have a MSSQL database with a table containing a row defined as Column Name Data Type Length Turnover decimal 5 also in Enterprise Manager I see Precision is set to 7 and Scale is set … Databases mssql |
| | hi, i have a table called exam, it has following columns ----------------------------------------------------------------- | ID | QUESTION | OPTION_1 | OPTION_2 | OPTION_3 | ----------------------------------------------------------------- now I've normalized it and put the exam options in another table called 'exam_option' table which keeps these options in rows instead of columns. Since i … Databases mysql |
The End.