7,494 Archived Topics
Remove Filter  | |
| | Hi,, i am a newbie in SQL server.. we have a database in our office.. I notice that since 2004 - 2008 our database growth was about 19GB, but since jan. 2009 to present our database grows from 19GB to 52GB... is there's something wrong happening in our database's configuration? … Databases mssql |
 | Good Day All i have the Following that table [CODE] ID | ACTV |VENU |STUD | TRIES ===================================== 1 1 4 162 0 2 4 5 104 0 3 8 5 138 0 4 15 2 68 0 5 15 4 291 0 6 21 4 171 0 7 22 … Databases mssql |
| | Hello all, Is there an easy way to edit the order of my colums in a table? Presently, my colums are: cust_num, name, email, location, bday_day, bday_month, bday_year, state I would like to list the "location" column after "state". Can anyone offer a simple suggestion. Thanks in advance. C- Databases mysql  |
| | hello everyone, i need a code snipet that can help me retrieve username and password and to authenticate the password in the database.. Databases mssql |
 | Hi all, 1) Users can belong to a specific group wherein when the group moderator publishes an event, its visible to all the members of group. 2) A normal user can publish event in his own calendar, to make that event visible to all users in group, the group moderator … Databases mysql |
| | Hi, I have a question regarding a SQL query. I am a complete noob, so please do not make fun of me. Here is a schema that I created: [code] JOURNALS(j_num, j_name, j_subject_area, chief_editor_r_ssn) ISSUES(j_num, i_num, i_date, i_num_pages) RESEARCHERS(r_ssn, r_name, r_address, r_phone, r_institution) ARTICLES(art_num, art_title, art_area_topic, art_abstract, j_num_submitted,date_submitted, j_num_published, i_num_published) … |
| | Hi, I am trying to transfer some data from a Mysql database onto a Microsoft SQL database. I would need your help on how to operate this migration as I am new to MSSQL. I have been looking on Google but there are not a lot of pages on that. … |
| | Hey, This is my first post so go easy :) I’m in the middle of designing a website users can download files from. I’ve searched the web and found the perfect example of what I’m trying to achieve which is something clear and simple ([url]http://www.getfreefonts.info/free_fonts.a.html[/url]) From the category’s at the … |
| | I am a Student working on a project useing mysql. I am trying to set up a view and keep getting an error that there is duplicate columns. Is there anyway other then specifiying each table.culumn to stop the view from trying to show both of the columns. If it … Databases mysql |
| | I have a table that holds a users id and a cd number, what I would like is to be able to only increment the cd number based the users id not just incrementing it every time a new cd is created table [code] CREATE TABLE IF NOT EXISTS `cdcreation` … Databases mysql |
| | Hello everyone. Basically, I am making a small site for my friends where we can create users and edit profiles and comment eachother. Like a scaled down social network site. The problem is, I really can't get my head around the whole idea of relational databases. What I have is … Databases mysql |
| | I have a query that works, I wanted to add another sum from another table, but when I do, the all the SUM values are wrong this works [CODE]SELECT Clients.ClientID, Clients.WholeName, SUM(CASE WHEN Payments.Creditorid = 0 THEN Payments.Amount ELSE 0.00 END) AS 'Admin Fees', SUM(CASE WHEN (Payments.Creditorid = 3) THEN … |
| | Hi all, I have a single table with both parent and child nodes, and each has an order number in it. I am trying to write a single query to output them in order, its for a navigation list with categories and sub-categories. I could manage it in code rather … |
| | The name of this question is oracle project Hello and Thank you in advance for any assistance. [B] System info: [/B] I presently use Netbeans6.7,MySQL,glassfish to work with learning JSF and java apps etc. [B] The Purpose of this post is: [/B] I recently was presented with a tutorial to … Databases java-netbeans oracle |
| | Hi, I have an insert statement that i need to refine...basically I need to trim the first couple of letters of whats trapped inthe field. so e.g. Z:\aaa\1.jpg needs to become aaa\1.jpg Im tried this but its not working [CODE]sImagelink = mid(request.form("Imagelink"),4,len(request.form("Imagelink")))[/CODE] any ideas? Databases mssql |
| | Hello, New here so hello. I need to transfer an Excel file to Mysql with a large amount of data. I looked on a few forums but have not found much. Do you know how to do this? Is there an easy solution? Thanks a lot. Databases mysql |
 | Hi I need a help in SQL,There is table called sales.Its contains the day,sales quantity.If I write sql like below [CODE]select day,Sales_quantity from Sales.[/CODE] Then result should be Day SalesQuantity Monday 20 Monday 302 Monday 50 Tuseday 30 etc.. The problem is I want to get result like below Day … |
| | A company has several employees and projects. Each employee may be working on several projects. Design a database to hold information about projects and employees, choosing some sensible sample fields and data. Write an SQL query to display the number of women and the number of men working on each … Databases data-structure database-design mysql |
| | Hi all... So, I am needing to sum all billable hours within a table... the problem is that it is returning rouded decimals instead... like .5 always comes back as 1 ... Here is my procedure: [CODE] Public Shared Function GetBillableTimeForTicket(ByVal SupportTicketID As Integer) As Decimal Dim conn As New … |
| | Hello to all, Am new to oracle sql, and I am using the developer to create new database. Unfortunately, when I try to create new connection and error appears saying that : Status: failure –lo exception. The network adapter could not establish the connection. Connection Name: NewDatabase Username: test Password: … Databases oracle  |
 | Hi, this is giving me a major headache and my boss wants the project wrapped up asap : / I have two views pulling data from several tables. The end result is this: CustomerTotals CustomerID numeric(18,0), ProductID numeric(18,0), Delivered numeric(5,0), Ordered numeric(5,0) SupplierTotals SupplierID numeric(18,0), ProductID numeric(18,0), Delivered numeric(5,0), Ordered … Databases mssql |
| | I need to make ten selections. One of all the datetimes in the last 24 hours, the next one from 24 hours to 48 hours, and on back in 24 hour blocks for the last ten days. I've tried various approaches to this, but this is what I currently have: … Databases mysql |
| | Hello I'm designing a database for my Computing Science department and I am having some trouble with the ER Diagram. Any help would be great appreciated. What I have so far is: Each course has a ID Code, title, is taken by one or more students and is taught by … Databases |
| | 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 = … Databases mssql |
| | I am trying to write a bulk import routine so that i will be able to import text files or csv files to SQL i have tried this and it's giving me the following error message. P: is the drive where the file is in currently. [CODE] USE [XYZABQ] GO … Databases mssql operating-system sql  |
| | Dear all, I’m stuck on a problem which I’m hoping someone might be able to help with in an SQL script. I have a table with RAW Timesheet data which includes entries for Absences. When someone enters a timesheet on a particular date for a two week holiday, if I … Databases mssql |
| | I got a query to calculate the percentage as , [CODE] Select votes, rating, votes/sum(votes) as percentage [/CODE] But I want to take the values from two different tables. I tried [CODE] Select elec.sum(votes) from elec, stat.sum(rating) from stat where year=2009, elec.sum(votes)/tat.sum(rating) as percentage; [/CODE] This doesn't work. plz help. Databases mysql |
| | Hello, I have a MySQL 5.0 Database used for management of my service, with 13 tables. The two tables most important now are "customers" and "cust_packages". The table "customers" has one column "cust_email". This column has e-mails of customers of the my service. The table named "cust_packages" has one column … Databases mysql |
| | Good Day All am restoring a Database Programatically in Sql. Now if the backup is located in the remote machine i use a Share [QUOTE]\\Vuyiswa\MyShare\[/QUOTE] but i will get the Following Error [QUOTE] Exception caught in: ExecuteStoredProc: The file "\\Vuyiswa\Databases\\REmoteTest33.mdf" is on a network path that is not supported for … Databases mssql |
 | Hi and I have been working on a project involving a rather large database. My question is "For a database with over 20529860 rows, is it better to have 3330 tables spreaded equally or to split into multiple databases or would it be better to have 49950 tables in the … Databases database-design mysql |
| | Hi, I am trying to get the primary key (which is number) from a field of the same table. however i encountered "Undefined index" shown on my screen. [CODE] $orange_insert = "INSERT INTO orange (orange_id, orange_name, orange_add) VALUES (NULL, '$val_name', '$val_add')"; $result = mysql_query($orange_insert) or die (mysql_error()); $orange_sel = "SELECT … Databases mysql |
| | I have following tables table1 nr_key1 nr_dad1 table2 nr_key2 value (repeated ~n times with same nr_key2 and different value) in table2 nr_key1 = nr_key2 After I have iterated through nr_key1 I want to use recursion to select nr_key1 = nr_dad1 and iterate again table2 with the new nr_key1. This should … |
| | i have a project that implements the using of database. i chose to use php as the application interface and mysql as the database. at the end of this month, we should submit the softcopy. now, i'm confused with the files of my project. i'm using wamp server, and in … Databases file-system mysql php |
| | I have some tables that i have created in SQL Server and i want to write a stored Procedure that will insert data on to one of my tables AND also be able to update say if i select record [CODE] CREATE PROCEDURE Sp_cust_SaveCustomer --ALTER PROCEDURE cust_SaveCustomer (@id int, @ … Databases mssql  |
| | |
| | or even make the searching faster when retreiving data. please kindly help me. thnx. |
| | Hi I wonder how I do to remove usersid from 1915 to 1945 for example in MS Sql? [code=sql]Delete from [dbo].[user] where user ID = 1915 to userID 1945[/code] When i add that i get this message: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword … Databases mssql |
| | Simply put, I need a better query. I have a table that contains 85000 rows, each row has a TITLE and an ABSTRACT (they are academic papers). What I need is to do a realistic SMART search in my query. Right now I'm doing[code]SELECT * FROM PsPapers WHERE Title LIKE … Databases mssql |
 | I have a database that needs to hold names of people from all around the world. Some names have special characters in them such as é and ¢ Is there a character set I can use that will accept any character no matter what language it is (with the exception … Databases mysql |
 | what do i need im a newb just wondering. have subscibed will be otofied of any posts. Databases database-design |
| | I created some data files with 'outfile ' command. The files are created in the mysql folder.{I use WAMP} I want to create those files in another directory. How can I do that? Thankx in advance. Databases mysql |
| | hi everybody ...could anyone tell what is the difference between deny and revoke of privileges from a user. Databases oracle |
| | Whenever I create a new database from a C# program and create tables for that database, the tables always show up under the creator's default database instead of being listed under the newly created database. This observation is from Microsoft SQL Server Management Studio Express. Is there some setting in … |
| | Hello i wish to retrieve rows from a table based on a particular column which contains null values in sql2000 server I try ed a lot but its not working please help me. Databases mssql |
| | One of the UPDATE queries I am trying to run is not quite working the way I want it to. I know this query is the culprit, but can't quite figure out how to fix it! Here's the story: ------------------------------------------------------- I have 3 tables: let's call them tblUsers, tblDueVisits and … Databases mssql |
| | Hello, I want to create database on SQL Server using Javascript and HTML. User will input following data. Server Name, Database name, File Sizes. When I will click "Submit" button database should be created on Selected server with entered name. I am using Client side HTML and Javascript. we need … Databases html-css java javascript mssql sql |
| | The reason is that : 1. I wish to run multiple databases on a single server. To do this securely each login must be granted db_owner on the database so we can use "deny view any database" to hide the other databases from view. (login can see all databases they … Databases mssql |
| | hi i have two tables, one is products, the other is for 'discounts' on those products... when adding a new 'discount' i want to avoid adding two discounts to a single product... so i was looking for some sort of Right Join which would exclude all products which have a … Databases mysql |
| | Hello all, i would like to know how it is possible to remove for example last 20 characters, or by specifing the string to remove. For example i have 2 rows (in reality there are more than 100, thats why im not working it out by hand) with the next … Databases mysql |
| | I created 2 tables 1 st table as csat csat_code csat_ou_cod csat_csaeid cus name CSA00001 ADM00001 6825 CUS08349 CSA00002 ADM00001 6826 CUS08347 CSA00003 ADM00001 6832 CUS08351 CSA02547 ADM00001 6824 CUS04150 table2 as csat_survey surveycode csat_code qns id ans id SUR00001 CSA02547 1 3 SUR00002 CSA02547 4 7 now i want … Databases mssql |
The End.