Databases Forum

I know everyone and his cat has one of these up but I'm just so stuck... I mean in theory I think I understand normalization and then I get down to it and I just... don't. I've been googling and looking through examples and I'm ready to tear my hair …

Trying to import a flat file into SQL Server using SSIS. The file format is like this: [CODE] Image: C:\folder1\1234\5678.jpg ColHead1 ColHead2 ColHead3 Data1 Data2 Data3 [/CODE] I need a result that looks like this: [CODE] ColHead1|ColHead2|ColHead3|ColHead4 ----------------------------------- 5678 |Data1 |Data2 |Data3 [/CODE] So the idea is that we extract …

I have a class registration form. The database has a semester table, class table, student table and registration table. I want a query to return a list of students that are registered for a class in an active semester. I have the query, but it returns each student twice. I …

Hi, I wrote a qyery: [CODE] SELECT introtext FROM jos_content JOIN jos_sections ON jos_content.sectionid = jos_sections.id WHERE jos_sections.title = 'Redaktores zodis' ORDER BY publish_up, DESC; [/CODE] If I don't use ORDER BY then it works. But with it it throws error: Query : select introtext from jos_content join jos_sections on …

I have to: Find the distinct names of all diners who ordered 2 or more portion of the same foods on the same day in the same restaurant. [CODE] SQL> select * from foodorders order by diner; DINER RESTAURANT ODATE FOOD ------------------------------ ------------------------------ --------- ------------------- ALICE BEST FOOD 09-APR-11 BAKED …

i have my interface built already and my sql database. i want to connect the interface to the database. i have four fields that is the lugword, meaning1, meaning2 and the search from the database can some ome help me

Hello, I have the following situation which I can seem to resolve. When I do an "ALTER TABLE" in mysql (v5.5) it hangs in with "waiting for metadata lock". Here is how I got there: - i have an xml which i want to import into a table; i use …

Hello Guys, I'm having the biggest headache over this issue. I have a system that I designed which uses a standard php login script to a MySQL database. The system has account registration etc. For the past 5 months I've tested multiple accounts and logged in with one primary account …

What would the diagram look like and what [B]relationships[/B] would there be? It [B]stores[/B] the [B]customers (patients)[/B][B] details [/B]and [B]drug information(prescrip?)[/B]What[B] entities [/B]would there be ? e.g. customer/patient, pharmacist or doctor? or both?

I have the function pt_replace: [CODE]function pt_register() { $num_args = func_num_args(); $vars = array(); if ($num_args >= 2) { $method = strtoupper(func_get_arg(0)); if (($method != 'SESSION') && ($method != 'GET') && ($method != 'POST') && ($method != 'SERVER') && ($method != 'COOKIE') && ($method != 'ENV')) { die('The first argument …

hi there, i am using a code to back (downloaded) up a database in a server and when i run the application it gives me an error saying operating system error 3 [CODE=C#] //Use this line if you have already created a bakup file. File.Delete(DBpath + "\\backup.bak"); this.Cursor = Cursors.WaitCursor; …

When i do a select on my db. example. a row with the column 'animal' has the value of 'Horse' select * from table where animal = 'horSe' doens't work?! How to make it work full all variations with capital or non capital?

Hi. I have this table named tblProduct, which contains fldProductID, fldProductName, fldValue fldProductName contains its name, and fldValue contains how much is the product cost. Now I am having trouble with updating fldProductID. Here's what my fldProductID look like. [QUOTE][B]fldProductID[/B][INDENT]G01 G02 G03 GZ01 GZ02 TX01 TX02 TX03 TX04[/INDENT][/QUOTE] Its format …

Hi all, I was trying to write a query to List all manager's names and how many employees they are managing. all the employees and managers in the same employees table and have a id number and and manager id number. can any body help with this?

Hi everyone, Here is my situation: I have a table of users in my database with all the usual user information it it. I have another table which lists the rights that each user has. this table has 2 columns 'Userid','Functionid'. Each user may have multiple rows in this table, …

hi there, i have a question in connecting to the server. when i log in to the server and connect to the ms sql server i can connect to the databases. but when i login to another computer and try to login to the MS SQL server management studio i …

Hi. I am stumped when trying to figure out how to make it so the name in one column is just listed once with nulls values underneath until the next column name. I'm sorry if I don't explain this right. I have this script: [CODE]SELECT NAME, SELLPRICE "Price Sold", COSTPRICE …

This question is more specific than general. I understand SQL a good amount, and understand JOINs and UNIONs etc, but I am having a real problem with a query I need. I have three tables: [CODE] ITEM: ITEM_ID ITEM_NAME WISH: ITEM_ID CUST_ID SELL: ITEM_ID CUST_ID [/CODE] What I need from …

We're having issues with database performance, and up till now, have done very little with indexing. We try to turn on full text indexes when available, but we do support (though we are phasing this out of our support)MSSQL2000, we try to advise our clients to use the newest available …

I'm trying to query several different tables using INNER JOINs but there's something missing in my code. I get all the results I need except that what I want in this case is that for example, when we make partial shipments, I need to have all the different shipping dates, …

hi there i have a database which is MS SQLserver 2008 and ihave a database called AdminApp. from visual studio 2008 i add the database and the connection is succeded, but when i get the connection string and add it to my DB class for the db string and run …

Dear all..before i give up after multiple trial and error attempts,can someone please help me with below query. I am trying to replace the path name D:\Downloads\Music\ (note the slash) to [url]http://mysite.com/Music/[/url] in mysql field name called "filename" under "songlist" table. Below is the query code that I tried ,but …

Hi. I'm having a problem on deleting a record using a function on SQL. DELETE FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG' This query shows and error saying: Cannot group on fields selected with '*'. I tried adding a specific field, like this: DELETE ServiceID FROM tblServices GROUP BY ServiceID …

Hi, I want to get the count(*) from all tables under a schema. How to can do this using a loop? I'm a noob at PL/SQL. I'm unable to find how to use the loop variable in the select statement. Here is what I've tried so far: [CODE]spool $DD/get_oid_dump.log; SET …

Hi, anyone know how i can find the last added entry in mysql db. i am aware of: mysql_insert_id(), this function returns the last id but I need to select the last row where $username = username.

[CODE] insert into mst_order_report(Capacity, Clearing_Alpha, Client_ID, Client_Order_ID, Cumulative_Executed_Size, Date_Of_Expiry, Entry_Time, Exec_Type, Executed_Qty, Executed_Value, Execution_ID, Hidden_Size, Inactive_Time, Order_ID, Order_Qty, Order_Status, Order_Type, Owner_ID, PAN_ID, Parent_Order_ID, Reason, Remarks, Side, Stop_Price, TIF, Total_Qty, Trade_Report_ID, Trader_ID, Transact_Time, Value, Visible_Size, Trading_Member_ID, Symbol) select * from order_report(Capacity, Clearing_Alpha, Client_ID, Client_Order_ID, Cumulative_Executed_Size, cast(Date_Of_Expiry as date), cast(Entry_Time as datetime), …

[CODE]20110319-04:30:00.772[/CODE] is the row of Entry_time column from order_report Above is in varchar Need to convert in datetime I am trying the below query but not working select Convert(datetime,Entry_Time,121) from order_report

i have three table member (memberid,m_name,statusid,address,DOB,phone) booking (bookingid, memberid ,sessionid, cost) session(sessionid, activity,location) (fk memberid, fk sessionid )BOOKING IS link with ( member pk )and (session pk) session activity is like football,swimming,badminton,tennis i want to run the following query find the name of all member who have booked any session …

How to convert this to 3RD normal form? [url]http://oi55.tinypic.com/aytvv5.jpg[/url] error in above table >>>>> Take c02(ID) bobby as lee.they both has to be the same Thanks

here is my code want to get records between two dates [CODE] $sql=mysql_query("SELECT * FROM `expense` WHERE `date` BETWEEN '2011-04-26' AND '2011-04-28'") or die(mysql_error()); echo $r=mysql_fetch_assoc($sql); [/CODE] i getting "Array" in output instead of the data please sort it out for me i am not getting it right

Hi All I have to tried to connect MySQL with remote databases(GT.M)i can successfully communicate with remote database and after a specific period of time i face the following error message [B] "ERROR 1296 (HY000): Got error 1 'No response' from remote host". [/B] can anyone guide me what kind …

Hello all, I have three table name with same data structure. So, I want to insert my data through store procedure by passing table name as variable with my data. Is it possible? Thanking You. Hakoo Desai.

Hi Guys, Can you please let me know if there is a sql command to list PK , Child and Parent of an identical table in oracle? Lets say I have a table called City , how can I get those information using SQL? Thanks

I'm using mysql 5.5.9 I used create database query to create a new database but this new database is not coming in mysql.db table can anyone tell me the reason y and even how to get the database in that table.

Hi, I am new to MySQL scripting. I used tee command to append my logs. But I wanted the log file to be cleared every time i execute the script. Is there any command to do that? Thanks Shiny

hi i get an error saying cannot login to the ms sql server, i did all the things restarted the server, and changed the authentication mode to mixed mode nothing doesen't work, i created an another login with mixed mode authenitication the same error saying login falied to user sa …

I have created a ER diagram fro this table [url]http://oi55.tinypic.com/aytvv5.jpg[/url] is it correct?my first ER diagram btw [url]http://oi52.tinypic.com/hx3ybk.jpg[/url]

Hi every body, Can you please let me know how can I modify following SQL algorithm to Disable/Enable all constraints existing in an specific table? [CODE] alter table (table name) disable constraint (constraint name) [/CODE] For example if I have a table called "GIS_Data" how I can disable all constraints …

Hi everyone, I am building a database of users for our website. It is an MSSQL database. Currently I have all the usual fields eg First Name, Last Name, email etc. There are different things that our users need to have access to on our site. At the current time …

I have a view with two tables and three fields tables are called SC011000 and SC33013 the fields are called SC01049 and SC33013 both are datetime fields. I want to make the third field show the biggest date. but i am doing something wrong I am typing in case when …

Hi, I am new to SQL and just trying to self teach myself... I have written the below script and I am recieving an error. If anyone could help this would be much appreciated... [CODE]SELECT (CASE WHEN SL_PL_NL_DETAIL.DET_NOMINALCR = NULL THEN SL_PL_NL_DETAIL.DET_NOMINALDR ELSE SL_PL_NL_DETAIL.DET_NOMINALDR = NULL THEN SL_PL_NL_DETAIL.DET_NOMINALCR END)][/CODE]

Hello Everybody! My problem is connected to the SQL Server Enterprise Managager. I worked with it for a day testing a database attaching/detaching it and after I closed the Manager the following problem occured. The local database seems to be dissapeared. However, the applications through the network reach it because …

Hi Guys I have to merge(insert)data from source database into target database(over 600 tables).The good thing is the both source and target tables have exactly same structure and constrains but I have to transfer only data that are not existing in target database/table.Right now I am using this code but …

Hey Guys, Iam John and a newbie.. Iam building a database to store the business rules in the database. For example the following expression Expression=(a=5 or b>6) and (c<7 or d=0) will be stored in the database as follows: Rule ----------------------------------------- RuleId |LHSCode | Operator | RHSValue ------------------------------------------ R1 a …

So, I'm a tech writer, not a database guy, but I've been asked to develop documentation for my company's databases. This means I have some questions. It seems obvious to me that there must be some SQL documentation tools out there, but I have no idea what is used for …

Hello, I have a query that needs to perform the following: where verified=1 AND where name is like '%$term%' AND/OR owner is like '%$term%' I have a basic knowledge of SQL and was wondering if the above is possible. I need the and/or because i would like it to return …

hello friends i want to sum up my table field data...my table name is fee_info and i the field i want to sum is exam_Fee... i have come out with a query but at last i am not figuring it out yet. here is mine code [CODE] mysql_connect("localhost","root",""); mysql_select_db("new"); $get= …

hello friends i want to add my table fields but i got a problem that when ever i add my field for example i enter two records one of ID 2313 having exam_Fee and transport_Fee and other having id of 2314 having same exam_fee and transport_fee.query for this which i …

Hi friends, I got a table as follows Name | idNo | started | type | entrytype ----------------------------------------------------------------- Nick | 12 | 12-02-2011 | 0 | 1 Sam | 14 | 13-02-2011 | 1 | 1 Paul | 12 | 14-02-2011 | 1 | 1 Jwal | 12 | 13-02-2011 …

my table structre like this ID nAME 1 Mumbai,Pune,Chennai i want output of name like this Name Mumbai Pune Chennai pl help m 'new to sql Thanks in Advance