7,494 Archived Topics
Remove Filter  | |
| | I'm trying to formulate the proper SQL query to pull a roster up on this database I was asked to produce for my kids' HS band. Arrghh. Any help would be great. I have 3 tables. [CODE][U]student[/U] student_ID {PK} first_name last_name email family_ID {FK} [U]family[/U] family_ID {PK} family_phone [U]adult[/U] adult_ID … |
| | I need to know whether there is a performance issue when dealing with the database(database operations)depending on the datatype size of a particular field of a table. I have a table with a SMALLINT size primary key. But there is a chance of having a big data range than this … Databases |
| | Hi All, I have my table with duplicate records. the duplicate records have the same ESN and Shipdate the difference is the time. there is no transaction in same date. That's why i would like to remove the other records. I need your help guys. How to this. 1. I … Databases mssql  |
| | LEADID ACCOUNTMANAGERID ActivityDate USERNAME Q6UJ9A08MZSN U6UJ9A0000IR Mar- 1-2011 KSHITIJ GUPTA Q6UJ9A08MZSN U6UJ9A0000IR Mar- 1-2011 KSHITIJ GUPTA ACCOUNTNAME Kayess Finance & Investments Kayess Finance & Investments show only one records for duplicate this o/p come from various join it just an sample data i have near about 250 duplicate records in … |
| | Hi, Can any one suggest the method to delete bulk records upto 1 lakh without specifying any condition? There's no Id to be specified in checking in the where condition. Please suggest an idea . Thanks In advance Databases mssql |
| | I have a table customer in ms sql and i have same table in Oracle. I want to insert data from ms sql to Oracle. I am not getting the solution. |
 | I have connected java with oracle over lan, in connection string i have provided the IP address, now the startup is very slow, how can i make it fast, i have already asked the same question in java forum but no responce, so i thought oracle expertise can answer this … |
| | hey guys!!! I tried downloading oracle 10g release2& 11g release2 and both of them failed during the universal download. On both links it told me it should be 5.1 or 5.2, actual 6.0? Can anyone please help me here. I tried doing this 2 times and the same result. I …  |
| | Hello to all reading this thread. I want to ask you a question about mysql records and more specifically deleting them. I have a database which has a table called orders. In orders I have fields: ID, Name, Date created, Date expire. My question is, how can an order be … Databases mysql  |
| | Hello, I've tried to search solution for selecting name from table1, for table2 id's. Table structures are like table1 (persons): id name created table2 (linking): sup_id emp_id where sup_id is id from table1, and emp_id is id from table1. Can I directly replace those ID:s with correct person names from … Databases mysql |
| | Is this code correct? It is supposed to get input from SMS messaging API and save it to database. Mysql database is created with Table inbox and 2 columns called ID & Msg. I want to know if this code is going to do the job? Else help me in … |
| | Back in February,smantscheff helped me with a problem where I was trying to aggregate data between two queries and after the suggestion of creating two views, everything worked perfectly. However, I failed to look ahead and see a potential future problem! The original thread is [URL="http://www.daniweb.com/web-development/databases/mysql/threads/347065/1473368#post1473368"]http://www.daniweb.com/web-development/databases/mysql/threads/347065/1473368#post1473368[/URL] and quite simply, as … Databases mysql |
 | Hi all. I have a database table containing the details of, lets say, Ninjas. It has a primary key called NinjaID. I have a second table containing a match-up of which Ninjas will be fighting eachother. This table has 4 Columns: 1.) MatchID 2.) BlueCornerNinjaID 3.) RedCornerNinjaID 4.) DateTime What … Databases mysql |
| | Hi to all, first of all thanks to all those who reply... appreciate the input I am using OpenContacts as an address book style program. However it uses a firebird backend db. I have a mySQL webserver and I want to synchronize the two databases by "Replacing All of Local … Databases mysql |
| | im pondering on some functions on MySQL especially on dates and times and i stumbled upon an idea where i can't find a predefined function that gets the next day of a specific day. For example: As of this post, the Date and Time is (GMT +8) : July 4, … Databases mysql |
| | Hi, I am developing database in Access & VB. My question is how can forms be displayed so that they automatically size to any screen whether it be 15" or 21", for example. Many thanks. Databases microsoft-access |
| | Dear All, I got few tables as below. So then what I do on any time I will calculate the total points collected based on each table via some of this queries like below. What I am using now is the sum function. I am confuse should I like run … Databases mysql |
| | Hey guys, I'm having an issue understanding how to write a table that uses an id and another id which both have dual keys. What I mean by dual keys is they use primary key and foreign keys. Example: Table Name = Enrollment Column Name = Sid, Csecid, Grade Data … Databases oracle |
| | HI friends..I have a tab delimited text file with country, city, Participants field.. Now, when I search for a particular entry for eg. Country England, then I want it to show all the cities associated with it Inot just one). My actual table looks like this. [IMG]http://i56.tinypic.com/2dceg4p.jpg[/IMG] Now, If I … Databases mysql |
| | What am I missing... I have looked and searched. Any help / direction? [CODE]-- DANIWEBOS DROP TABLE ENROLLMENT CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE_SECTION CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE CASCADE CONSTRAINTS PURGE; DROP TABLE TERM CASCADE CONSTRAINTS PURGE; DROP TABLE STUDENT CASCADE CONSTRAINTS PURGE; DROP TABLE FACULTY CASCADE CONSTRAINTS … Databases database-design oracle |
| | I have sql table with 3 columns id, parentid and name.I have attached the table i have . Also i have attched the table output i want. In the name column ,there are so may values out which yes and no are two values which occur more than once. I … Databases mssql |
| | Create a script named *just_lee_trg.sql* that contains the PL/SQL code to create a trigger named *books_qty_on_hand_trg*. The trigger should be set up to fire whenever the quantity on hand for a book has been updated. When the quantity on hand becomes zero, it should call the *insert_reorder* procedure and pass … Databases oracle |
| | Hi I am trying to build a MySQL database. I have made a table where some fields are VARCHAR and others are INT. All of them are null. One of the columns I made is Vote which is INT(5). Now I am trying to import data from a text file. … Databases mysql |
| | Im using the rank function for a route order on my import. The script works perfectly fine except when I have to stops at a location (locationid,stored as a GUID). This is how it currently looks locationid Rank 0A0F4E97-699B-E011-B139-00188B47C528 1 0A0F4E97-699B-E011-B139-00188B47C528 2 110F4E97-699B-E011-B139-00188B47C528 3 110F4E97-699B-E011-B139-00188B47C528 4 0E0F4E97-699B-E011-B139-00188B47C528 5 0E0F4E97-699B-E011-B139-00188B47C528 6 … Databases mssql |
| | The MYSQL db has a Location field with entries like: CAN CAN ON CAN ON, CAN BC CAN AB, CAN BC NY OH CANFIELD, OH TOLEDO WA, OR, CA Thus the location field can have multiple entries, all separated by a comma, but still held in the single Location field. … Databases mysql |
| | hi guys! i have a problem regarding the queries i coded. my first query is to display the category name, description and maxscore: SELECT c.cat_name, g.maxscore, g.description FROM grp_performance INNER JOIN category c ON g.cat_id = c.cat_id the problem is, i don't know how to delete the row in the … |
| | I m try to solve this problem Add a column named *reorder_quanity* to the *books* table that will hold a value up to 999 with a default value of 10. 4. Update the reorder quantity of all books to 10. 5. Update the quantity ordered to 1 for all books … Databases oracle |
 | Here is the image of the table of the Question [url]http://oi55.tinypic.com/2d0gkmh.jpg[/url] Here is the First question(in the image) [url]http://oi52.tinypic.com/2ztix5l.jpg[/url] Above one is question (c) help me to answer that this is the other question(below, as Text) d) Create a database view to display the above output of part (c). help … |
| | i'm not getting any results for the query. I'm sure it has something to do with the apostrophe and back slashes [code] $search = "q test'yes"; $search = mysql_real_escape_string($search); mysql_query("SELECT * FROM block WHERE name LIKE '%$search%' ORDER BY `id` DESC",$this->connect); [/code] When i echo it out i get this … Databases mysql |
| | Guys, Can you help please to compare or check the records from Mytable1 to MyTable2 if exist or found. and i have to count the records with not null. Any idea. you can modify my script. [CODE] elect a.ESN b.ESN FROM MyTable1 as a Left outer join Mytable2 as b … Databases mssql  |
| | Hello, I am currently working on a stored procedure that shows the time of day as an integer value: 456, which means 4:56. I was wondering if there is a way in SQL that I can convert this int in to a datetime value. So instead of the time appearing … |
| | hi... I have a doubt. please clear me that what is the difference b/w sql, mysql & oracle.? please reply soon... |
| | Hello All I'm converting an access database to MS SQL for a webapp and have a question if anyone knows how to do this. 4 fields [TimeReported] [TimeOff] [TimeOn] [TimeAssigned] Access only stored time, so date is incorrect. 1 Field stored date separately [Date] I would like to take each … Databases mssql |
| | I have tried for hours now trying to figure out how to do this and I'm sure its impossible, I have tried the following queries and still searching for the solution. I need to display the subcategories, subcat_title table row based on the condition the table row cat_id is equal … Databases mysql |
| | select companyname,sum(sale) as TotalSale,sum(purchase) as TotalPurchase from invoice group by companyname Having companyname IN (select companyname from invoice) It returns sum only for those column whose all sum are not blank, how can i show blank sum values I mean there are 7 companies but only 4 records are shown. … Databases oracle |
| | What's the notation to add data from a variable to existing data in a field? mysql_query("UPDATE stk SET some_field = '????????????' WHERE id = " . $upc_key . "") or die(mysql_error()); Databases mysql |
 | how do retrieve the last record if its id or other fields are unknown...or simply i need to move the record pointer to the last record in a table...thanx a lot... SELECT * from stud_infos WHERE stud_id = 'HOW DO I DO IT?' |
| | How to take a user table backup from that user account? I mean i want to give him grants to take backup... also query to take backup. Databases oracle |
| | how to populate treeview from multiple columns of sql data table I have attached my sql table here.from that table,i have to populate a treeview of the below form; -outlook ---------overcast -----------------------------yes ---------rainy ----------------wind ----------------------strong ------------------------------no ----------------------weak -------------------------------yes ---------sunny ---------------humidity ------------------------high --------------------------------no -------------------------normal ---------------------------------yes. It is readable like this; if … |
| | The below line generates this error. Can anyone gives me a solution Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\wamp\www\MySite\php files\approve_page.php on line 25 [CODE] $query = "UPDATE transaction SET approved_status='1' WHERE account_number='$account_number' AND tran_id='$_POST['tran_id']'"; [/CODE] |
| | Hi all, [INDENT] i am facing a serious problem working with MySQL and Nhibernate 2.1.2.4.0 named queries. I have written a stored procedure and i am calling it in C# using a flat class to map the database fields. My problem is it seems to work fine with Mysql 5.1 … Databases mysql |
| | CREATE TABLE `employee`(`employee_no` CHAR(4) NOT NULL,`emp_name` TEXT,`employee_sal` INT NOT NULL,primary key (employee_no); << I typed this and it says there is an error (see below).I can't see what is it.000webhost.com Mysql server [CODE]Error SQL query: CREATE TABLE `employee` ( `employee_no` CHAR( 4 ) NOT NULL , `emp_name` TEXT, `employee_sal` INT … |
| | Hi Guys, Kindly please help me on how to this in scripts. How to calculate and get the average aging based on the Aging period. I could not figure out on how to do this in script. btw, even the format is not like my sample it's okay, unless i … Databases mssql  |
| | HiEveryOne, Does anyone know how to get the data where startdate is more than today'sdate and enddate is less than today'sdate and if enddate is NULL. Thanks for the help Databases mssql |
| | Im in need of big help... (sorry bout the size of the post :$) Im just getting started in databases and need some magic.... Im running on the server; * Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 * MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $ * … Databases apache client-server mysql perl php  |
| | what is the .net code for adding year in this form like 2001-2002,2002-2003, in dropdown with the asp.net |
| | hello everyone , I'm facing a problem in inserting data in TEMPORARY table. i can do it by simple query easily. but i want to do through [CODE] for Ex. i have bunch of query which i'm executing through SET @QueryText="Select ID from employees limit 5"; //it contains bunch of … Databases mysql |
| | Hi All, When I run this script using bulk insert i got an error message but when I try the first 6 records there is no problem. can anyone give the reason and what is the problem? [CODE]Use chrisMartin Bulk Insert SampleTable_Jonel FROM 'c:\planning\ProductRecoveryDataFeedytd_3.csv' --Sheet 1 With ( DATAFILETYPE = … Databases mssql  |
| | Hello All Developeres, Please Read Below Senario. I have one table Supposed "Emp(EmpID,EmpName)" Now There is data with Name "testName1" and "testName2" in EmpName Field Now I need query which fetch all record in asceding order for EmpName Field and Record with "testName1" and "testName2" will must display at [B]last[/B]. … |
| | [code]StrSQLQ1 = "SELECT " & _ "CustomerCharges.JobOrderID, CustomerCharges.ClientID, CustomerCharges.ActivityDate, CustomerCharges.TaskName, CustomerCharges.Charges, CustomerCharges.LineSeqID, CustomerCharges.IIDNo,CustomerCharges.consignee CustomerCharges.marking, CustomerCharges.rate, CustomerCharges.m3, CustomerCharges.tonn,CustomerCharges.labor, CustomerCharges.storg, CustomerCharges.overtm, " & _ "JobOrderHeader.JobType, JobOrderHeader.CustomerName, JobOrderHeader.LedgerNo, " & _ "JobOrderLine.LorryOutDt, JobOrderLine.FL, JobOrderLine.VesselIn, JobOrderLine.ContainerTruckNo, JobOrderLine.ContainerSz " & _ "From " & _ " { oj (WMS.dbo.JobOrderLine JobOrderLine INNER JOIN WMS.dbo.CustomerCharges CustomerCharges ON …  |
The End.