Databases Forum

Hello there, I am in the need of some serious guidance/advice/direction. I am comfortable and familiar with creating DB's, however my knowledge/skills/abilities simply revolve around MS Access. I have been approached by someone that wants their existing web based DB to be overhauled. They have provided me with a very …

I give two parameter like year & period. For example year = 2009 & period=3 Result : 22 working days in this month Plz help me.

i want to insert data into third table for two tables that is first table:table struct: pid -->int,name-->string ..etc second table :cid -->int,parentid-->int....etc third table struct is:pid-->int,cid-->int now iwant to insert data into third table from the other two tables pid from first table is a prime key and pid …

I have a db, that I feel is efficient, but I have trouble displaying the data the way I want. I can either keep the db and change the display, or I can redesign the db and get the display format I want. I'll try to explain my situation and …

hiya ,pls where can i get an explanatory note on normalization?I will also need an example for each form starting from the 1NF to 4NF.

Hi i have created a website for my client using PHP and mysql . The client need to backup a table in database as excel file every day. Well he had no idea about coding and all ... He need to backup using a simple way. Please anyone let me …

All, Have a form with over 189 controls on it and trying to automate the save. I currently use the following script to init the fields: [code] On Error GoTo Err_Msg For Each ctl In Targetform.Controls ' 100 = Label, 106 = CheckBox, 109 = TextBox, 111 = ComboBox Select …

I can read in an SQL table ("Person.Contact") from AdventureWorks and step through it one row at a time, but when I try to save a record, either one I'm inserting or one I'm editting, I get the following exception: Incorrect syntax near ','. Must declare scalar variable "@ContactID". Here's …

i am trying to mutiply and add 2 dnamic texts on a php form, but i do not seem to get the reply, but i get the following results "sum (4 + 1)" This is the code that i typed in [ICODE](<?php echo $row_standings['w']; ?>+<?php echo $row_standings['d']; ?>[/ICODE] The 4 …

hi. my thread title seems strange but its really about comparing unlike values as an output. I want all values that are not LIKE the other values. To make things clearer. Here's my query: [ICODE]SELECT Records.[Officer ID], Records.[Plate Number], Records.[Violation Commited], Violations.[Violation Code], Records.[Street Name], Records.[City of Apprehension], Records.[Vehicle Category], …

Hi everyone, I am trying to create a vacation planner where users can log in and save their plans. I have created a table called planner_plans and this is going to contain the main info such as title etc. but how do i make it so that when the user …

I am getting the following error sometimes. When the user load gets heavy I'll receive the following error. Would puting cftransaction around my update statements work? ODBC Error Code = 40001 (Serialization failure) DiagnosticsODBC Error Code = 40001 (Serialization failure Microsoft ODBC SQL Server Driver SQL Server Transaction (Process ID …

HI I am very pleased to join this forum I am new to SQL programming , I am facing a challenge I need to copy the data from one table in one sql server to the same table in enother SQL Server From Server A table (Employee) To Server B …

I am getting an "Connection must be valid and open" error. After some research I have found two possible reasons for this: malformed sql or bad connection string. Since the error is being thrown on a second .executescalar statement I will assume the connection string is working. I have two …

Hello all, I'm having the following problem, I have three tables, Person, Income, Outcome Person has the primary key : ID Income has two fields : PersonID [Foreign] and IncomeAmount Outcome has two fields : PersonID [foreign] and OutcomeAmount I need to make a query that gets the summation of …

hi friends I am new to SQL SERVER I am using sql server 2005 enterprise for server and express for client m/cs. Having issue while connecting from client to server. i have read some tutorials on net. while connecting to server from my client machine, i usually get error: 18452. …

hi, i have 3 cols in my db col 1 ( unique identifier ) col2 ( varchar ) col 3 ( integer ) how can i retrive the 3 greatest values from the database on the basis of col 3..

I need some help creating a query that will pull a series of record that falls with a date range with specific interval. for example: I would like pass in a date like getdate() - 10 for start date and getdate() for the end date. However, the dates in between …

Has anyone moved their SQL Server's into a virtual environment using VMware? If so, what has your experience been like? thanks, GM

I have these two tables.. [B]Product[/B] ============================= ID Title Description ============================= 1 My first product First description 2 My second product Second description … … … …. …. …. [B]META[/B] ============================= ID PRODID KEY VALUE ============================= 1 1 StartDate 22-MAR-2009 2 1 EndDate 23-MAR-2009 3 2 StartDate 28-MAR-2009 4 2 …

I have two tables, student and teacher. I have an email table because a student can have more than one email. But, so can a teacher. Should I include a foreign key of both student and teacher in my email table or create two separate tables, that is, a student_email …

I have three tables : 1. tblDiseases(diseaseId, diseaseName) where diseaseId is the primary key 2. tblSpecializations(specializationId, specializationName) where specializationId is the primary key 3. tblDiseaseSpecialization(diseaseSpecializationId, specializationId, diseaseId) where diseaseSpecializationId is the primary key All diseases need not have an associated specializationId. In the disease registration table with fields for person …

Hi I entered http:\\mandar\isqlplus on the address bar but I,m getting Invalid syntax error. mandar is my computer name. Pls help me out Is there any way to solve this error

Hello everyone, I need help. I have two table name: Table 1: resortid resortlocation Table 2 resortid resortname Now I want to get the maximum of resortlocation then getting the name of that specific resort also. I am having a hard time. Can someone please help me? Thanks.

Hi there..I have been given the daunting task of taking years of tournament scores and develop a database to calculate the bowlers tournament average. Each bowling season bowlers bowl in 3 mandatory tournaments and one optional. Each tournaments' scores and number of games (usually 6 or 10) are kept to …

hi i want to merge two rows in a table. but a little confused.. Please help!:confused: the example is as shown below Record #1: [B]Nikhil [/B]Bhat [B]1Jan2009 [/B][B]Married [/B]ABC Record #1: Nikhil [B]Ong [/B]1Feb2009 Single [B]DEF[/B] Meged Record : Nikhil Ong 1Jan2009 Married DEF There is a primary key 'ID' …

Hi, How do i order results for most relevant one? [code]Select id, title from data where (titleLIKE '%PHP developer%')[/code] id title ---- ------------------------------- 1 ASP developer 2 WEB developer 3 PHP 4 PHP developer In this case, it should be displayed in this other 4, 3, 2, 1 OR 4, …

Dears i need to design a database for real estate agency, the price is based on the size of the unit multiplied with the meter price, for example if an unit size is 200 meter and the price for 1 meter is 10 US$ so the price for this unit …

Good Morning Friends, I have a SP that is Supposed to Restore a Database from a Backup. In some Clients this works well but in those particular client its a Problem. The version is SQL 2005. Here is the Code that fails [CODE] set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go …

hi I have got a table for internet accesswith user ID, it has 3 column user ID, starttime and endtime, i want to make another column which will show how many mins or hours that user was logged in to the internet. can anyone please help me... thanks kaz

I am working on an ASP.Net website with SQL Server database and C# 2005 as the programming language. In my database I have two fields namely RDate and RTime. RDate stores the date of the record and RTime stores a time like 09:00 AM, 09:15 AM, 09:30 AM etc. The …

Hi I'd like to know if is possible update a record when load a table. The update must be over a record with a primary key. For example: I have a record with: id|date_begin|date_end|data 2|02/03/2009|NULL|0 and I want that line to be update when a record like 2|02/03/2009|10/03/2009|56,7 comes. Is …

Can I copy data from one database to another by a sql script? I have an active database we'll call dbo.active and a temp database we'll call dbo.temp both are a customer list and all the customers in dbo.temp exist in dbo.active. I want to copy the notes from dbo.temp …

I have written my simple query using update and in a file with a .sql extension. However, I cant seem to update my table and yet at the end of the input it shows me 1 row updated I would also want to know how I can do 2 updates …

i have a code like this [CODE]select * from tableX group by fieldA order by fieldB[/CODE] this code sort according to fieldA. but i need to sort according to fieldB. please help me ??

I have an ASP.net 2.0 website with SQL Server as database and C# 2005 as the language. On my webpage I have a calender from which I choose a date and display only the date part in a textbox (readonly) in the format dd/mm/yyyy. But internally SQL Server uses m/d/y …

A simple question I hope. In using the OOPs mysqli protocol how do I get the number of rows returned in a select query such as: [code] $queryStr = ("SELECT * FROM entry where username='$userin' AND password='$passwordin'"); [/code] Thanks! WBR

Hi, I hope I am in the right place for this... I am looking for some help with a query. Basically, I am using a shopping cart which has option groups and I have created 2 new option groups. I now need to add these option group id's to all …

I installed SQL Server 2008 Express, basic edition (SQLEXPR32_x86_ENU_Bootstrapper.exe, version 9.0.30729.1) without any problem. Then I attempted to install AdventureWorks Sample Databases for SQL Server 2008 (SQL2008.AdventureWorks_All_Databases.x86.msi). This attempt failed because SQL Server 2008 Express, basic edition doesn’t support Full-text Search, which AdventureWorks requires. So I uninstalled SQL Server 2008 …

I am developing ASP.net 2.0 website with SQL Server as database and C# 2005 as the programming language. In one of my tables, I have a filed named RTime of char datatype to store times. The values of this particular field are like 09:00 AM, 09:15 AM, 09:30 AM, ------ …

Hello, i'm designing a demographic database in which i have to register information about cities, counties and population. In details: - each city has its name, county in which it is, a unique ID, TotalMen, TotalWomen, TotalPopulation and the details about population organized in the following way: + for each …

Hello, I'm in the process of designing an app which basically functions as a multi-part application(multiple forms) incorporating a basic cms and payment tracking. I'm having trouble coming up with the db structure for the multi-part application. The site needs to be flexible enough to: -Have multiple forms -Store/track form …

Hello everybody My problem is that I'm quite new in oracle admin/dev so I need some help pointing me how to limit the number of days of data stored in a table. I have some datasources that come in files periodically. I'd like to limit the days stored for each …

Hello Experts, I am fairly new to MS SQL Server 2005. I am trying to create a table where a column has the restriction of allowing alphas only. I know how to achieve this in Oracle using String functions. But am not able to do so in MSSql. The replace() …

I have three tables: posts, topics, and forums. Each row in post table has a topic id and a author name. Each row in topics has an id that corresponds with the topic_id in posts, and then it has an id for the forum that it (the topic, containing the …

I have a query that brings though a list of passenger names, is there a way in which I can set the length of each of these names to equal 10 characters. So even if I have shorter names eg "bob, demarcus, adam and scott" they would display with the …

I am using the syntax: REPLACE(str,from_str,to_str) to replace data in my table. However I have a slight issue I would like to address, when I have the following records jon | jonathon | jonas | jonny and I do the replace with REPLACE(names, jon, '') I am left with | …

hello all.. im a newbie..in both complex database design and oracle pl/sql ,and im very unsure/confused about the structure of my tables and how to normalize some info. ok so heres the situation. i have a company,employees are distributed according to dept and section and category.each category has number of …

Hello all. When I run the statement: select regdate,description,machine_id,machine_nm,status from iris_log.dbo.tb_log_info where regdate like '%23%' I get the result: 2009-01-23 08:05:06.000 Administration Software is Closed. Operator's Name:admin But if I do: select regdate,description,machine_id,machine_nm,status from iris_log.dbo.tb_log_info where regdate like '%-23%' the result is null... why?!?! TIA, -hdmnp

Hi, [code]INSERT INTO money (salary) VALUES ('100,000,000.00')[/code] 100,000,000.00 is stored as 100.00 in decimal (14,2). I don't know what is wrong? Thanks