Databases Forum

I would like to update 2 fields values from one record to a set of records in the same table: I tryed this: [CODE]UPDATE dd SET dd.comment = y.comment, dd.author = y. author FROM Table1 dd LEFT OUTER JOIN (SELECT * FROM Table1 WHERE Idx=1234) y ON dd.vin = y.vin …

Hi I have a problem where dot is used in a table's column name. Say that there is a column called 101.name in a table t1. How do i reference this column in the following: select ... from table t1, table t2 where t1.101.name='test' This doesn't work because of the …

I have a query called in a CSH script which is a simple select. I would like to write the result of the select statement in a a flat file but when i set the "SET HEADING OFF" and "SET FEEDBACK OFF", i get a blank line written to the …

I need to download data automatically from a remote server. Its a CSV file, and i need to unzip it, and store the data in a mysql database that i created. There are multiple databases. The first section below is one of the databases that someone helped me with and …

I am trying to deploy a report to the Reporting Services Server but keep running up against this error: [QUOTE]An error occurred during client rendering. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'dataSource1'. (rsErrorOpeningConnection) Could not obtain information about Windows NT group/user …

Before I begin i'm sorry if this is a noobish question. Basically I'm trying to import a 'forum.sql' file into mysql so that I can access and manipulate it through a Java servlet. The path to the sql dump file is /home/floyd/Desktop/forum/forum.sql so i open a terminal window, cd into …

Hello All :pretty: i m new in this forum and i want to ask if there is examples about sql bcz i have lab exam on sunday and i don't know the type of questions so i m friad from that :S i use Oracle Sql*plus and thanx alot 4 …

Is it possible to get the columns name from a select statement involving more than two table. eg [CODE]SELECT a.field1, a.field2,b.field3,c.field4 FROM a,b,c WHERE a.field1 = b.field1 and a.field1 = c.field1 [/CODE] is there a mysql statement that returns a record set containing field1, field2, field3, field4 that can be …

Hi everyone. Can someone please recommend a SQL editor (other than SQL Developer) that will allow me to test out my SQL statements & queries outside of the DB environment. I will predominantly be working in a windows environment, but may move to a linux environment at times. Will be …

This is my database it executes with no error. [CODE]--Kudler Fine Food Database Create Database [VALMKudler_Fine_Foods] On Primary (NAME=VALM_KudlerDB, FileName="C:\POS410\VALM_KudlerDB_dat.mdf", SIZE=10MB, MAXSIZE=100MB, FILEGROWTH=10%) --Kudler Fine Foods LOG ON (NAME="VALM_KudlerDB_log", FILENAME="C:\POS410\VALM_KudlerDB_log.Idf", SIZE=5MB, MAXSIZE=100MB, FILEGROWTH=20%)[/CODE] This is my table it executes with no problems [CODE]--Job Tittle Table CREATE TABLE [VALMKudler_Fine_Foods].dbo.tbljobtitle ( jobID …

In defining MS Access tables where a 1 to many relation exists what is the best way to define a table containing the “many” records. For example, a database with orders and line-items might have the “line item” table with an order-number and a line-number which would define a unique …

I've been trying to learn how to program for several years now. I've struggled with everything from C++, C#, to Python, but never got passed simple DOS text based screen programs that were very short. I'M now 24 and I work in a factory. I would love to find a …

Hello, We are currently using a Mysql database: we would like to change. Now, we'd like to use Mssql. Only problem is that most of the data and other information are on Mysql. Can you help us with this? Thanks a lot for your help.

Good Day All i have a Table with the ID Field that was not an identity Field. This Field has not Duplicates. Now later i want to Change this numeric Field as an Identity Field like this [CODE]--STEP 7 ADD THE IDENTITY BACK IN TABLE MTM_ACTV_STAFF ALTER TABLE [New_Jaco].[dbo].[MTM_ACTV_STAFF] ALTER …

Hi Trying to pull this off in one query but my and right & left joining is giving me unusual results... i have a 'product_style' table, an 'product_item' table, an 'addto' table and a 'removefrom' table - im monitoring when products are added/removed to/from the cart... and want to pull …

last semester, i did an airline reservation system. we need to create another system for this semester. any suggestions? [except inventory and enrollment systems] thanks

Hi all, I would like to ask for some help in a query. I am trying to create a view and this view should show the student name, project name, hours spent on the project, and number of units the project is worth. However, if the project is not done …

Hi I have this data [code] CustBid idProduct bidAmount bidDate 1 272 165.00 2009-11-20 09:05:31.640 1 272 155.00 2009-11-20 09:05:25.480 4 272 95.00 2009-11-19 12:40:44.973 4 272 85.00 2009-11-19 12:40:40.377 1 272 85.00 2009-11-12 11:20:52.400 1 272 85.00 2009-11-12 11:20:52.400 4 272 75.00 2009-11-12 11:11:02.080 1 272 65.00 2009-11-12 11:20:20.170 …

Ok i wa swondering if i could get help on this: Jack’s Jail is a new private facility set up to cash in on the current shortage of prison places. The jail is to be set up in Manchester using some old buildings that are surplus to requirements (so some …

I use SQL Server 2005 and I create function.Below I mention the Function that I created. [CODE] CREATE FUNCTION dbo.udf_GetCountryID(@Name varchar(50)) RETURNS VARCHAR(1000) AS BEGIN Declare @Description varchar(4000) select @Description = coalesce(@Description + ',' , '' ) + countryCode FROM dbo.Test_Table where CommonName='Japan' Return @Description END[/CODE] After creating function I …

Ive been looking around and havent been able to find anything like this yet.. I am new to mySQL. Im looking for a function like the "where" function of a query string.. but insted of it being exact i would like to select "where" datafield "contains" text.. example.. item is …

I am trying to write a query in my .net app and I'm having trouble pivoting the table since the columns are generated dynamically (based on a month range selected by the user) [CODE]SELECT SUM(HEALTH_MTTR) AS MTTR, SUM(HEALTH_OTR) AS OTR, SUM(HEALTH_REPEAT) AS REPEAT, SUM(HEALTH_CHRONIC) AS CHRONIC, SUM(HEALTH_TOTAL) AS TOTAL, (CAST(CAST(YEAR([DATE_RESOLVED_FOR_CLOSURE]) …

Hi I have a column named 'ExtRefNo' which of varchar datatype. The values can be numbers alone(eg; 101) & values comprising characters & numbers(eg:101A3) My requirement is if the user search for ExtRefNo between 100 & 105, it shud retrieve all ExtRefNos ranging from 100,101,102,103,104 & 105. Need not include …

Please tell me can we insert data in multiple table with single query in mysql. For example i have two table with name `table1` and `table2` and fields in `table1` are 'id' auto incremented and primary key, second field is 'name' data type varchar of 25 and another table `table2` …

Hello, When trying to use mysqldump, I got this error message: [QUOTE]mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect[/QUOTE] According to the MySQL Documentation Library, error 2003 means that my network connection has been refused and that I should check that there …

Hello, Being on Access, I would like to transfer some data onto Mysql. But I cannot. Is there an easy way to transfer data onto Mysql? I am thinking that it should not be that hard to do. Thanks for your help.

Hi I am taking MIS class and i need help with the EER diagram and i tried making it myself but teacher told me that it is a process diagram not an ER diagram please help me here is what i have tried: please click on this link [U][url]http://yfrog.com/j2mytryj [/url] …

I have database with a table called orders. The structure is below Index, OrderIndex, OrderNo 111, 1 112 , 1 113 , 1 114 , 2 115 , 3 116 , 3 I want a query that will loop thorugh the database and make the result Index, OrderIndex, OrderNo 111, …

Hi I am taking MIS class and i need help with the EER diagram and i tried making it myself but teacher told me that it is a process diagram not an ER diagram please help me here is what i have tried: please click on this link [url]http://yfrog.com/j2mytryj[/url] and …

I am a first time poster and couldnt find a relevant category to post in so chose this as most are viewing.My wife has a company that currently uses an old sage product as a database. It runs in dos and will only run in windows using an emulator, but …

Hello to all, We are currently using Excel and are thinking of changing. Now we would like to use Mysql. Only problem is that all our customer addresses and other information are on Excel. Can you help us with this? Thanks for your feedback. (Of course title is bad... )

I've got a database which is getting quite large and slow to query. I only really need the last month of entries for most situations so I'm looking to create structure-copies of two of my tables and then regularly move data from the 'live' two into the 'archive' two if …

DRIEND FRIENDS, I am given a project "hospital administration database" Could you please guide me how to start and proceed. Thanks and Regards. Shariq

Hi All, I am able to connect to the database from backend that is toad.But from the java application i can't . The error is from the line [CODE]Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@vrs1.india.mitey.com:1591:dapps");[/CODE] I am getting the following error: [CODE]Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 7 at oracle.security.o3logon.C1.r(C1) at oracle.security.o3logon.C1.l(C1) at …

Hi. I have a question to advanced SQL programmers/users. I would be very grateful if you could explain me in simple words why we use multiple joins on the same table (for example multiple left outer joins) - what benefits it brings? examples would be appreciated best regards q

Dear Users, I have used SHA1 encryption method to encrypt password and stored in login table as a blob field. Now, to authenticate the password, i need to decrypt it. I am not able to decrypt. Please help me to decrypt password

Can I store a photograph in a mysql table. ? What type it takes...how it is done. Do i have to store only the path??? please explain me.

what is the differances with SQL tables and relation modelling?

Hi, I have this view: [CODE]DROP VIEW digits; CREATE VIEW digits AS ( SELECT TO_NUMBER(SUBSTR(rounded_cost, 1, INSTR(rounded_cost, '.' -1))) left_digits, TO_NUMBER(SUBSTR(rounded_cost, INSTR(rounded_cost, '.' + 1, LENGTH(rounded_cost)))) right_digits FROM roundcost );[/CODE] It allows me to create it but the values stored are apparently not valid numbers. When I try select * …

Hi, I have created a temporary @table and while inserting ,i am using dynamic sql.But this is not getting executed and throws an error that "EXECUTE cannot be used as a source when inserting into a table variable" i am using SQLServer2005. Dont know where i am going wrong [code] …

I am designing a database system to store salary information. It includes different tables (salary,personal info , ect) I want to make it use for different companies. Also i want each set of data to be separated. (by company wise). (i.e. i dnt want all the employee names of every …

Hi all, I have a column in my table that auto increments as a counter as new records are added. I would like to renumber the entire column and have it start at 6000. Can anyone suggest an sql line that would allow me to acomplish this? Thanks in advance …

I'm currently studying SQL and have created two tables (Orders and Inventory). I have been trying to create a trigger on the "OrderDate" column of the Orders table to update the Cur_Stock value (to subtract the Quantity ordered from the Cur_Stock) on the Inventory table whenever a new Order is …

I currently run an installer app that will install a DB on a VM server. However this fails because the when oracle is called to begin the oracle services start up but the newly installed DB will not. It works on a physical machine but not on the virtual server. …

i made a registration script but i dont know how to make the whole website and all its directories protected please help.

[code] private void SubmitActionPerformed(java.awt.event.ActionEvent evt) { try { Statement s = con.createStatement(); Statement s1 = con.createStatement(); Statement s2 = con.createStatement(); Statement s3 = con.createStatement(); ResultSet rs = s.executeQuery("select MAX(Guest_ID) from Guests"); rs.next(); int maxGuestID = rs.getInt(1) + 1; //s1.execute("insert into Guests values(" + maxGuestID + ",'" + txtUserName.getText() + "',' …

Is this the right place to ask the following? I have 2 tables in two different MS Access DB's. Access allows the ability of inserting data from DBA.table1 into DBB.table1, using the format [dba].[table1].[dbb].[table1]. Here's my problem. Using a single SQL Statement I can't figure out the following. DBA.table1 has …

Hey guys I am Using Oracle APex and have created a some tables running SQL commands. I am now trying to INSERT multiple rows of data into one of the tables but am running into issues. I firstly tried the following: [CODE]INSERT INTO stock_item_table (stock_item_no, item_desc, item_price) VALUES(11,'item1',12); VALUES(12,'item1',22); VALUES(13,'item1',32); …

Hi everyone, I am tasked to alter the front-end of the database and have been given the whole wad of PHP files and also an .SQL file. My question is, Why i cant see any changes to the database front-end when i change the .sql file. (I tried creating a …

Hi there,am tinuke a software developer. I use ASP well,but i just started learning PHP/MYSQL. Is there a way to create a hyperlink data type like we have in MS ACCESS? I need to upoad an address to the database as a link.Pls help :sad: