7,494 Archived Topics
Remove Filter  | |
| | Hi and thanks for letting me post my question here. I'm trying to create a select statement based on the following conditions, but first, let me visualize the tables. These have been created to give you an idea of the content of the tables but are not the actual values, … Databases mysql |
| | Hello everybody, When I run the following statement, it returns 3660 rows. [icode]select * from symbols where code = 'AAHSY00';[/icode] But when I run the following statement, it doesn't do anything and goes in a never ending loop. [icode]delete from symbols where code = 'AAHSY00';[/icode] Any idea on how to … Databases mysql |
| | Hi, I have a 3 tables needed to be inner join before I got a full details of a transaction history (What item, shipment details, quantity, who bought it etc). The involved tables are ShopCart,ShopCartItem and OrderData ShopCart: [code] CREATE TABLE dbo.ShopCart ( ShopCartID int IDENTITY (1,1), ShopperID int NOT … Databases mssql |
 | what is the most efficient way to make a "contacts" table in mysql database. like a user can change the relationship between him and another user. like i cant figure out how the database should look to be most eficiant. ive been through two ways. the first was a column … Databases database-design  |
| | Dear SIR, I am using sqlserver2005. Table1 has a column named bill_no and its type is text Now I want to change its type "Numeric" When I do this the it displays this error message --------------------------- Microsoft SQL Server Management Studio --------------------------- Conversion from 'text' to 'numeric' is not supported …  |
| | Hi, A while back you guys helped me make a query that returns all clients that have not made a payment in 90 days. this works good. I now want to exclude those who have never made a payment. I tried to add in [CODE]Exists (Select Receipts.DateReceived from Receipts)[/CODE] but … Databases mssql |
 | Good Day All i have the Following sp [CODE]SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_Timetable_View] @selectionType varchar(30), -- either Venues, Staff, Subjects, Curricula etc... @selectedItems ntext, @selectedTerms ntext AS /*This Part of the code was Representing the Sp Get_Staff_Cycles_For_TimeTable due to temp table scope , i … |
| | I have a store procedure in which i need to get values from another procedure, so i called it and tried to insert in table variable. but i got the "An INSERT EXEC statement cannot be nested." error message. anyone please give solution as i've already spent 2 days searching … Databases mssql |
| | [icode] Hi all there, I need your help in my project of "online examination”. I am developing this for my lab. frontend: ASP backend: SQL Server 2000 Now the requirements r: 1. I have to generate papers which randomly select 100 MCQs from table and displays on client computers. The … Databases client-server mssql |
| | [COLOR="Red"][/COLOR]hi frnds !!! I am an engineering student of 3rd year and i want to make a DBMS project so please suggest some good n unique projects on dbms. I'll be really grateful.Plz help me Databases engineering oracle |
| | Dear all, I've thus far created a simple Access database to keep track of all the pumps my (mining) company uses. What I want to do, is create a form which will automatically archive previous data if new data is written into it. For example, I have a pump that … Databases microsoft-access operating-system |
| | Hi, I'm working on a simple dating website with member profiles. I need to do something really simple, but I'm too tired to do this.. There is a profile table, login table and a profile_view table: profiles: profile_id, name, picture, etc.. login: session_id, username, time, etc.. profile_view view_id, profile_id, session_id … Databases mysql |
| | Hi, Can anyone help? I have 2 table each over 2M records and it is taking ages retrieving records. 1. A 'product' table that contains all products in store. 2. The second table is the 'offer' table which contains all offers related to the products (e.g price,store,product condition). 1. 'product' … Databases mysql |
| | I m using a table GATE_PASS which has a primay key named GP_ID.the structure of GP_ID is 0000/MM/YY. I want to start a new series from 0000 after 30th june of every year.anyone could help me???? Databases oracle |
 | Hi and I have a database with over 32 million entries and whenever I try the below mysql query or simular it crashes the sql server unless I use phpmyadmin. I have 4 columns all indexed and all are the char() type with a fixed length. Below is an example … |
| | I am tring to import a database from another server that is 10gb in size the database came to me as 10 files xaa xab xac xad etc. I ran a command to dump the 10 files to 1 10gb file mydatabase.sql When I first tried to import via command … Databases mysql |
| | I'm trying to paste some text into a memo field and am getting the message "The text is too long to be edited". The text is 64K, which I believe is the max. I even did a character count on it that came to 64,360 and the limit I learned … Databases microsoft-access  |
| | I am trying to build a crm like database with some billing functionality. The way our client base is setup we could have a client that wants to be billed based on a group of client codes and others individually even if they have multiple client codes and still others … Databases |
| | Hello everybody. I'd like some help with a query. I have a database named 'base1' which contains many tables. Some of the tables have names like 'track1' , 'track2' etc... which have identical columns. I would like to select all the tables beginning with track and show the data of … Databases mysql |
| | Hello everyone, While writing to the SQL Server database, I might encounter the below error message: “Error 823 I/O error <error> detected during <operation> at offset <offset> in file '<file>'” This error message may occur every time when I start SQL Server and access the MDF file. Thanks in advance. Databases mssql |
| | I am having trouble with a page where i need to insert data into a SQL field. It comes up with this error 7 times: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in / i would post the actual php page but its over 1000 lines … Databases mysql |
| | The code snippet below is the beginning of a script I've been working on. What I need to figure out is make sure that I can generate the corresponding day last year. The business logic is such that I am supposed to compare sales data from the last business day … Databases mssql |
| | Hi All! I'm setting up a very small DB to be used for customer based product reviews. There are two tables: [code]product_tbl: id int unsigned auto_increment reviews int unsigned // number of times product reviewed product varchar(45) [/code] [code]review_tbl: id unsigned int product_id int unsigned // id from product_tbl price … Databases mysql |
| | I am trying to create a trigger that updates one field in a table different from the one being updated/inserted. My create trigger code looks like this: [code]CREATE TRIGGER before_insert_ddsw BEFORE INSERT ON `ddsw` FOR EACH ROW SET products.count - products.count +1; [/code] When I try to create this I … Databases mysql |
| | What normal form is violated here? A telephone call is uniquely identified by telephone number and time of call. These candidate keys compose the composite primary key. There is an attribute/column “telephone location”. telephone number|time of call | telephone location(precise) Does it help if the telephone is mobile? Just thinking … Databases oracle |
| | Hi all. I've been making a site for my gymnastics group. I've got some background on both programming, mysql and PHP, mainly from university classes. However, all the projects where done in localhost, and now that I'm getting in the "real world" I'm having a few problems... The two main … Databases mysql |
| | Hi, When i try to restore a database, I get this error [CODE] ubuntu@ubuntu:~$ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 44 Server version: 5.0.75-0ubuntu10.2 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. … |
| | first of all i'm a newbie to databases and particularly mysql. i downloaded and installled mysql community server and mysql gui tools. now i want to create a local database and access it through mysql gui tools. please, give me detailed guide for it. |
 | I am starting on a next to impossible journey to build a database with many records and with relational databases at a later date possibly. The primary database I am going to build will have approximately 10 million records in it. Each record will have 75 - 100 items of … Databases mssql |
| | I was wondering if it was possible to this: example [CODE] if exists(Select * From table) select item from table set returnValue = 1 Else set returnValue = 0 [/CODE] Or if there any other way of doing this this |
| | Hi all, Am having trouble trying to retrieve records using the following SQL statement: [code=SQL] SELECT distinct(dbS.tCline.mobile),dbS.tCline.msg,dbS.tCline.dest, dbS.tCline.reply,dbS.tCline.status FROM dbS.tCline,dbLaw.FORMER_GREY where dbS.tCline.msg LIKE '%'||dbLaw.FORMER_GREY.C||'%' and dbS.tCline.msg like '%ADMISSION%' [/code] My problem now is that, the resultset retrieved includes everything from dbLaw.FORMER_GREY.C instead of only those rows that match dbS.tCline.msg rows.Please … Databases mysql |
| | Hi all, I wanted to execute the query stored in a table with given intervals. I have a table called "calculations". it has the following structure: id | period | sql | result | now, in the sql field, I store the sql clause to be executed. In the period … Databases mssql |
| | Hi there everyone, Im looking for a solution regarding a project im involved with which needs to run a script that search's between dates. Im running a table like this example: ID - date_begin - date_end - price 1 01-01-2009 31-01-2009 1€ 2 01-02-2009 14-02-2009 2€ 3 15-02-2009 27-03-2009 3€ … Databases mysql  |
| | I started to learn SQL recently. I downloaded some kind of assignment, where the goal is to design small database. I have two tables listed below: [CODE]create table SEA ( SEA_NAME varchar(50)constraint sea_prj_key primary key, AREA numeric(18, 0), );[/CODE] and: [CODE]create table NATION ( CTRY_NAME varchar(50)constraint sea_prj_key primary key, AREA … Databases database-design mssql |
| | I am not a database person by far. I know how to efficiently use MS Access. I posted a topic earlier in the design forum and received good responses that have led me to want to use MySQL. The database I want will eventually be fairly expansive. To start with … Databases database-design gui mysql |
| | |
| | Would like to create a temp table at the start of my Code for pull only a small result set that I then can use for my final result. Thank you, David Databases oracle |
| | Hi all, I faced up the following problem: I have a table: ID|server | target | action ---------------------------- 1 |a | b | attempt 2 empty row 3 |a | b | success 4 empty row 5 empty row 6 empty row 7 |b | a | attempt Does someone … Databases mssql |
| | I have a huge database which contains certain categories of products and their sales figures. I want to find CATEGORYWISE sale per Month. I have written a query for that. but I had to write 12 queries for 12 months. This is a sample Query for Month April I am … Databases mssql |
| | I have a scary query on MSSQL 2005 here... Got a wiew that returns 2110 rows... and a table of cca 1 500 000 rows. Now, when I run this query [CODE] SELECT TS.col1, TS.col2, count(*) AS Number FROM view_scary VS LEFT OUTER JOIN table_scary TS ON VS.IdContact = TS.IdContact … Databases mssql |
| | hi all, Im desperatly looking for a .db format rhyming dictionary and have managed to get hold of three database files which I think will be VERY useful to me but I cannot open them. Can anybody help me to get them open? I have attached the files in a … |
| | HI Guys I have an issue, I would like to know if anyone can suggest how I can achieve what I want. I have two tables, a user table and a media table. The media table has a FK, User_id , referenced to User.User_id. Table structure User: user_id username password … Databases data-structure mysql  |
| | Hi, I was wondering if it is possible to update one table with another tables values depending on a where condition, such as a insert into or using a join as a subquery. I have successfully got a windows application to do what I want it to do but it … Databases mssql |
| | I have a query that looks good to me but MySQL does not agree. I am using the DATE_FORMAT function and I do not see what is incorrect so I am hoping some one can point it out. [code] SELECT title, DATE_FORMAT(event_date '%Y-%c-%e') AS event_date FROM event WHERE event_date LIKE … Databases mysql |
| | Hi Gurus, I am attempting to install KB970892 on SQL Express 2005SP3, and I am unable to do so, due to a SQL suspended installation. When I try to continue the installation (which I have no idea what is it trying to install - I have inherited this server the … Databases mssql web-server |
| | Hi all, I am having a bit of an issue with a table I added (we'll call it 'new_table', with primary key 'key_id') to a PostgreSQL database I am working on. I recently created a table whose primary key is a serial int4. I have a standard query I run … Databases coldfusion postgresql  |
| | Hope someone here is more experienced than our current database programmer (no offense to him). We have a business search and directory website that just launched. It was developed using flex with msSQL as the database. Here is the problem... We want the keyword field to be searched so that … Databases mssql |
| | So the following command is working great for me but I want to pull and parse data twice in one query with the sustring command. I have a good bit of syslog data being dumped into one field and I need to run multiple substring commands to print it correctly. … Databases mysql |
| | Hi everyone, I have a problem in MS SQL. Due to academic nature, I am supposed to use a query to find out the present applicable tax rate (GST, Good & Sales Tax) without altering the table. The table has 3 tax rates, 1: WEF (With Effect From) 2004 Jan … Databases mssql |
| | I would like to insert to some table's columns input in UTF-8 characters. 1. what property of the column should I change to support this action, should it be 'Collation' or other property (like 'encoding' as well)? 2. I am using Microsoft SQL Management Studio. How can I change property … Databases mssql |
The End.