Databases Forum

I have tried several different things with none providing the correct results. Any help is appreciated. I have the following: Table A Table B Pallet_No Pallet_No Qty Qty I need to return: - All of the Pallet_No's from Table A that are not in Table B - All of the …

I need some help I have managed to get this far (as below), from thatI can put a AAA_NUMBER and be able to get that record details and thats the 1st step that I wanted the 2nd step that I want is say if the DOCID is not available I …

Hi, I've imported a Visual FoxPro database to MS SQL Server 2008 and had a couple of queries; The VFP tables used Numeric(5,0) for the Index fields, but I'm thinking of converting them to Integers in SQL Server. Is there any issues I should be aware of? A co-worker keeps …

Hi, i m simran,a be student of cs .i want to make a project an minor project on any topic.plz help me plz rep quikly. Thank you.

i am using SSRS 2005. In my dataset there are some blank rows and in SSRS is showing blank rows. Is there a way that i just show rows with data and ignore blank rows. i set the visibility property but it is showing blank line. dataset: a b c …

Hello all, my first post. I have identical tables in my db. Is there a way to create a view with dynamic query to combine/union all the identical tables into one view? dbo.table.x-1 dbo.table.x-2 dbo.table.x-3 dbo.table.x-{n}

Hi. I have a web application whereby I perform a search through 4 fields, namely:book serial no.,tel no.,gender and publishing date.In my jsp page variables picking the values respectively are:serial,tel,gender and datez.These are submitted to the java class.Currently, I perform my searches as follows(in java class): /***********************************************/ [code=Java]//......after connecting to …

Good Day All I have the Following Query [CODE] DECLARE @CurrentTime DATETIME SET @CurrentTime = CURRENT_TIMESTAMP select tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description], convert(varchar,datepart(hour,tb.starttime))+':'+convert(varchar,datepart(minute,tb.starttime)) [Start Time], convert(varchar,datepart(hour,tb.endtime))+':'+convert(varchar,datepart(minute,tb.endtime)) [End Time], tu.name [Requested by] from tbl_booking tb inner join tbl_resource tr on tb.resources = tr.id inner join tbl_user tu on tu.id = …

Hi, I hope someone can help me creating a sql for the purpose i have. I have a table named case_score_t with these columns: id, case_id, user_id, score, created_date I am interested in picking the rows with the greatest created_date, for a certain user_id. I now this SQL with give …

I have around 2 million vouchers of some fixed denomination (say 10 and 20)[CODE]create table vouchers(pin varchar2(20) primary key ,amount number,status char(1),extra_value number); create index IDX_AMOUNT_STATUS on vouchers(amount,status);[/CODE]Typical values [CODE]amount,status ,count(status) 10 N 1000000 10 U 700000 20 N 300000 [/CODE]For each payment transaction,I fetch one voucher wrt.transaction amount and …

I have to make an ERD diagram using this scenario case and I'm not sure if I have all the required tables/fields in my ERD. Is my entities normalized up to 3NF? Are the relationships correct? [CODE] Background The Brisbane Driving School was established in Brisbane in 1992. Since then, …

Hello, I have a two tables created to apply keywords to a given entry: Table: File FileID (int, pk, auto incr) Name (varchar) Table File_Keyword KeywordID (int, pk, auto incr) FileID (fk) Keyword (varchar) Given that I have a record in table File with 2 corresponding records in table File_Keyword …

Hi, I tried to restore my decompressed database [B]'cyberview_db_2809_2009-10-27_17h30m.Tuesday.sql'[/B] using the command : [QUOTE]mysql -h localhost -u root -proot123 info < /backups/daily/cyberview_db_2809/cyberview_db_2809_2009-10-27_17h30m.Tuesday.sql[/QUOTE] but there was no restoration. I checked the [B]/var/lib/mysql[/B] directory where all restored databases are located, and in the 'info' folder, the only script that was available was …

I have be struggling to turn the below while loop into a foreach loop with no result, so I am asking for help here on how to do this. [code] $query = "Select * from TIME_TABLE Where Extract(month from DATE_FIELD ) = DATE_FORMAT(NOW(), '%c') and Extract(day from DATE_FIELD ) = …

could someone point out the error in the followin php/mysql code [code=php]$strSearchVal = $_GET['q']; //database connection.. //... $strSQL = "SELECT DISTINCT area FROM hospital where area like '%'+ $strSearchVal; "; $result = mysql_query($strSQL); while ($arrThisRow = mysql_fetch_array($result )) { echo '<li>' . $arrThisRow['area'] . '</li>';[/code]

Help! I think that this should be easy but I have not been able to find the correct VBA code to get the Form to print only [U]the current record [/U]not all 1651 records. I have a command button (Print) and walked through the wizard correctly to print "only the …

hey i'm starting with a dbms project on commonwealth games . i want to use sql . can anyone please suggest me with what all i can include in my project??

Hi, I am doing a student progression system where the application is able to keep track of student marks. I have a problem currently and I've been spending nights on this. Let me briefly explain. Marks are calculated based on their hurdles. So for instance, H1 = xx%, H2 = …

I am receiving MySQL error 1265 when I try to insert records into a table and after googling this error I am no closer to understanding the problem. Here is the error message that is returned: Warning Code : 1265 Data truncated for column 'DATE_FIELD' at row 1 Here is …

In the view below, I need the line "[COLOR="Red"]isnull(wwr.packed_qty, isnull((select sum(qty_on_hand) from lot_loc where item = coi.item and loc like 'P%'), 0)) packed_qty,[/COLOR] " to include a "[COLOR="red"]or 'S%[/COLOR]'", so that both P and S are found, but I get a syntax error when I add it. What is the …

it seem my connection string doesnt work? [code]$connect = mssql_connect("192.170.10.798","sa","gasd") or die(mssql_error()); $test = mssql_select_db("banex", $connect) or die (mssql_error()); [/code] whats wrong with my connection string?

I installed WAMP5 1.7.0 When I try to access localhost & phpmyadmin, it asks for a username and password. I'm pretty sure that i didn't configured any. I installed the same thing in another computer, and it worked. what could be the problem?

how do i get started with MySQL and get the command prompt like MySQL monitor to write the command for creating a database in MySQL?

Hello, Ihope to find some help in here, i have the following diagram [URL=http://img143.imageshack.us/i/13503390.jpg/][IMG]http://img143.imageshack.us/img143/6704/13503390.th.jpg[/IMG][/URL] and i want a query which return Emp_ID, Pro_ID note; i can get these values but by 2 queries as the following; [code=sql]select Pro_ID from Projects where Dep_ID in (select Dep_ID from Departments where name = …

What is the best way to generate a set of dates based on today's date? Essentially, what I wanna do is: 1. Get Current Date 2. Populate a table with future dates 6 months apart and go up until I reach, let's say, 12/31/2020 I have looked at some of …

hi guys, I have 2 tables, one called neworders which stores the part_id and num or parts and a 2nd table called parts which has all the part details including cost. tables are as follows [code] neworder part_id(primary key) number_of_parts parts part_id(primary key) 7-8 more columns, eg size, desc, sup …

Hi... I want to write a IF Condition as follow: [CODE]set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO Create PROCEDURE [dbo].[abc] AS SET NOCOUNT ON; BEGIN Declare @add = 0 as int Declare @change = 0 as int Declare @remove = 0 as int Select abc.value as 'Name' if (History.OLDSTR == …

I have an assignment that states >Research on Microsoft SQL Server, Oracle, and MySQL. Briefly describe each database application. What are their inherent benefits or limitations? Assume a pro or con approach: Based on your research, which would be the most reasonable approach to this solution and why> All i …

Hi, I'm making litle CMS with PHP+Mysql. Can you tellme measures for prevention for SQL Injections ?

I haven't used the mySQL permissions mechanism to any great degree & could use a little help while still at the design stage. Is it possible to grant certain users access only to certain RECORDS within a table (based on the value of a field in those records). If not, …

Hello guys, how can to make correct query if in the typed values have a special chars (e.g. ' ") ? If the typed values have a one special char I know how to make the correct query, but if it have more then one special chars then I don't …

[code]"SELECT tbl1.staff_ic, tbl1.staff_name, tbl2.dec_status,tbl4.location, tbl3.post,tbl3.grade FROM staff_detail tbl1 INNER JOIN staff_declare tbl2 ON tbl1.staff_ic = tbl2.staff_ic INNER JOIN staff_post tbl3 ON tbl1.staff_post = tbl3.num INNER JOIN staff_department tbl4 ON tbl1.staff_dep = tbl4.no ";[/code] isn`t my coding is right?? why when i execute my command just certain data are appear and …

Hi all. I am writing a utility to manage virtual users on a mailserver w/ mysql backed. Unfortunately I am having performance issues when querying for the user's last access date/time. DB has this structure table [B]users[/B] [CODE]+------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra …

We have been using dbase4 in our workshop for all our database requirments for the last 12 years. for example our stores management, finances, salaries, challans, quotations etc. Now i want to upgrade to open source software, but i am quite unsure as to whether "mysql" will fulfill all my …

Hello, I would like to know if there is an easy way to transform the following table CarId | PropertyName | PropertyValue 1 | Size | XL 1 | Name | Porsche 1 | Color | Red 2 | Size | XS 2 | Name | Smart 3 | Name …

Hi I developed report using sql server reporting service.I used parameter to assign value for sql query.I want to use "LIKE" keyword in using parameter,How i do that?i wrote coding below what u wrote before.I used @con as parameter. [COde=sql]Select FriutID from Friut where friutName like'@con'%.[/COde] Once I write above …

Dear all, I am trying to submit my data on a php created form to mysql database where it is separate by 2 tables (device) and (location). As some of the devices shared the same location, 2 tables are created as below. For location table, i had created 2 fields: …

Hello! I need some help please.. i searched a lot, and tried everything... can someone help me please.. here's the deal: i have this select: [CODE]SELECT * FROM localizacao, cliente, dispositivo WHERE disp_id = clien_disp_id AND disp_id = local_disp_id ORDER BY local_id desc[/CODE] it's output: [URL="http://i.imagehost.org/0746/tabela.jpg"]http://i.imagehost.org/0746/tabela.jpg[/URL] but what i really …

I am a new SQL user and I have created my code but when I execute it I get this error : [COLOR="Red"]Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Job_Title' in the database.[/COLOR] I do not understand why I keep getting this same …

Hi, i have created a sp, that is taking too much time (more than 35 sec, is it more?). [Code] SELECT top 11 ROW_NUMBER() OVER (ORDER BY hjs_job_details.date_posted desc, KEY_TBL.RANK desc) AS Row, job_id, (case when len(job_title)>59 then (substring(job_title,0,59)+'...') else job_title end ) as title, company_name as Source_Org, source_company_name as …

Hi, I am creating a website where users will be able to submit forms. In the form they will be able to submit text and uploaded images. With regards to uploaded images, once they are submitted, what is the best way to save them? Is it to a MySQL database …

I'm mapping out an entity relationship diagram to try learn more about database design. I currently have approximately 17 tables that map out a quotation management system that quotes customers prices for products and/or services. I've been working on it for a number of days now but I am unable …

As the title says, I'd like to select a certain number of rows from a table starting from a specified row. So for example, I have a table with 250 rows and the rows are numbered incrementally using a column called 'ref'. I now want to select rows 51-100. How …

Below are the steps of how my basic clinic management system will flow. Please help to comment. Clinic Flow Chart: 1. Patient approach the counter (manually) 2. Patient provides IC to the nurse (manually) 3. Nurse searches the patient details (automated) 4. If the patient details is found 4.1 Nurse …

I am new at oracle and working on a small project. I am trying to find "[" in a field and produce from that point to the end of the field. My code is as follows: [code] declare startPos PLS_Integer; endPos PLS_Integer; begin set startPos := (Select top 1(instr(description, '[', …

Hi, could someone please help me, i'm in great need of some advice. I have a sorta simple scenario from which i gotta build a database from, can someone please shed some light on the matter, no matter how small your input is. thanks The database must allow for clients …

hi dear, i'm going to develop database that can access file in the user profile folder. but, i dun know how to create link in database mysql. i have 5 field in database.username,password,email and file. file contain link that access the file in file://C. i dont know how to do …

I want to select from a table only when a field repeats more than once. For this I have: [CODE]Select title, Count(*) As Cnt From poss_titles where Cnt > 1 Group By Title Order By Cnt desc[/CODE] But it says invalid column name cnt. How should I refer to this …

Hello people, Well The problem that I am facing is: I have a date in string format like 30 Jun 2009, how can I insert it into MYSQL table as DATE data type? I created the table and declare data type for Date column as DATE, when I insert 30 …

Hey guys, I'd like to create an access database for a vaccine clinic I am managing in a large slum here in South Asia. So basically I want to create a form that auto-populates. Say a baby comes in: I open a new form, assign a unique id (probably the …