7,494 Archived Topics
Remove Filter  | |
| | All, Trying to get a date WHERE statement to run to pull all records for the month. What I have is: [code] Dim SQL_Str, DatStr, MonVal MonVal = Get_Month(TargetForm![cboxMON]) DatStr = MonVal & "/*/" & TargetForm![cboxYER] SQL_Str = "SELECT * FROM qryREPrev WHERE ([tim_ted]= like #" & DatStr & "#)" … Databases microsoft-access |
| | First, let me say I'm a huge believer in the benefits of normalization. (Though I still have much to learn about it.) That said, I can't think of any way to normalize this beyond its current form (which is kind of shoddy in my opinion.) [url]http://img14.imageshack.us/img14/7229/relations1li6.jpg[/url] I'm designing a database … Databases database-design |
| | I am doing the following report. Write a report for a large bank on the benefits that cloud computing can bring to their database system (Oracle). Could anyone tell me I can find informaion to help me do this report? Databases cloud-computing oracle  |
 | hi i want to create a trigger for update in mssql. in my trigger i want to know which row was updated how can i achieve this info ? Databases mssql |
| | I have a table in MS SQL DB, the data was recorded with redundancy, is there an easy way to remove all but keep only one, for example: [ICODE]id name age dept --------------------------- 1 alan 20 A 2 william 23 B 2 william 23 B 3 mike 30 C 3 … Databases mssql |
| | Hi all, I was thinking of using Triggers to take care of my history tables. Two questions remain: 1) Transaction Scope I handle complex Operations in my DataAccessLayer (C#,ASP.NET) with Transaction Scopes. For example: [code]private void InsertFamily(FamilyDTO) { using (TransactionScope scope = new TransactionScope()) { try { InsertFather(); InsertMother(); InsertBrother(); …  |
| | Hi, I'm looking to set up an ecommerce site for a client with around 1800 products in it. There will also be around 100 customers that receive different discounts on each of these products. unfortuanately this is not calculated as a percentage but rather each individual customer pays a different … Databases database-design ecommerce |
| | Hi I want to know how to write storedprocedure when search creiteria is Present. Here the query to give the list of "select ID, Salesmennummer , Salesname Commision, Areacode from sales_master Areacode Salesmennummer Salesname Commision 1 1000 Rams 200 2 2000 Johny 1000 I Want to search above list by … Databases mssql |
| | Hello, My first post and I am hoping someone can resolve this strange dilemma. I am creating a text file by exporting the results of a query. One of the fields is a phone number that is formatted 999.999.9999 Unfortunately not all exported phone numbers are correctly formatted in the … Databases microsoft-access |
| | Hi I have two tables that I want to use to build a third. They have a many-to-one relationship for one of the columns. Table A has the "one" side of the many-to-one relationship. Table B has many rows that have foreign keys referencing Table A. I want to write … |
| | Hi All, I am mysql newbie. Please have alook at this querry. [code=sql]SELECT b.date as date, a.tirthankar_name as tirthankar_name, a.kalyanak as kalyanak FROM table1 a, table2 b WHERE a.mass = b.mass AND a.paksh = b.paksh AND a.tithi = b.tithi AND b.date BETWEEN CURdate( ) AND (CURdate( ) +9) ORDER BY … Databases mysql |
| | I'm currently having problems in designing a database for a loan project. This is my current design: [IMG]http://img264.imageshack.us/img264/4396/coopdbjx7.png[/IMG] ("member_int" is supposed to be member_id. The software I'm using cropped it. :( ) Here is what the relationship should be: [LIST] [*]A member can have 0 or more loans [*]A loan … Databases database-design finance |
| | Hello everybody, I was asked to design a history functionality for my database, which means that every record should be stored with a timestamp, comment (created, edited, deleted) and a user. In my eyes there are 2 possibilities: 1) Store all entries in the same table, and add created and … Databases database-design |
| | Hi, I am designing a model of networking web, I have a user model and friendship model. Now I want make that when one user have accepted a new friend, the others friends of this user could see this last activity of her friend. How is the best form to … Databases web-design |
| | hi everyone.. im a very begginer in database for my ide application i need to create an in-memory database.... can anyone explain me hw to do that....??? thanks in advance.... Databases ide |
| | Hi guys, I need some help please. I am new to SSIS. I created a SSIS in BI and when I run it it works fine (All it does is to run a select statement to get data and save it into a flatfile. The server I'm accessing is on … |
| | Hi Guys I have designed reports in Discoverer Plus and the users are viewing the report using viewer. My need is that suppose there is a report which is made. Now if some user views the report by changing the layout and save the changes. Now problem is the change … Databases oracle |
| | hi i have a table which contains a datetime type column. i want to create a stored procedure that gets a surtain month and year as parameters and returns all the rows with the date column in the month and year range i sent as parameter. for example if i … Databases mssql |
| | I have a query which works in MYSQL 5, but doesn't work in MYSQL 4.. anybody ?? [CODE] SELECT DATE_FORMAT(DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 0 - '52' WEEK), INTERVAL 2 - DAYOFWEEK(CURDATE()) DAY), '%v') as date, DATE_FORMAT(DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 0 - '52' WEEK), INTERVAL 2 - DAYOFWEEK(CURDATE()) DAY), '%Y%v') as date_ordered [/CODE] Databases mysql |
| | i created a new user with all the privileges in mysql and it didn't work. no user works except "root with no password" which is why i created several user and tried it...still didn't work....if anyone know what is wrong....please lemme know.... thank you.... Databases mysql |
| | hi i'm trying to edit gridview rows. the grid columns are template cplumns. i added the commandfield buttons for update. i wrote a rowupdating event: [CODE=asp]MonthTable.Rows[e.RowIndex]["FirstEnter"] = ((TextBox)(MonthGridView.Rows[e.RowIndex].Cells[6].Controls[0])).Text;[/CODE] on runtime i get this error: Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.TextBox'. what have i done wrong ? Databases mssql |
| | Hi, How to connect to remote server with storedProcesdure sp_addlinkedserver where the server has an instance SQL2005. suppose the servername as 'SrvName\SQL2005'. Also please provide the procedure how to delete a remote server from sysservers table. Thanks, Ukbasak Databases mssql |
| | I just finished a job interview/exam and I failed. I really don’t know how to implement this problem using an MS SQL. You could check the exact question/problem below: [I] There are two tables, NAMES (ID INT IDENTITY (1,1), NAME VARCHAR(255) ) and RELATIONSHIPS (NAMEID INT, PARENT_NAMEID INT) linked via … Databases linked-list mssql sql |
| | So, I've got a bit of a conundrum that I cannot for the life of me figure out. Here's what I need to do : In column PO_I, look for column ITEM with lowest # in column Seq_I. If column Ship_Q < Qty_Ordered, look for Ship_Qty within ITEM with next … |
| | Hi I have made a website where it is possible to see the days program on one page, it updates itself so it is only for that day. But now I wan't to be able to insert a picture that changes position according to what time it is. For example … |
| | |
| | I am sorry to take the liberty to email you directly, but I am in a really tight situation that I cannot seem to figure out. I am creating a database in MS Access. I have created several tables that I would like to link with each other. I created … Databases microsoft-access |
| | Hi! A bit of a stuck-up. I have a problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this … Databases microsoft-access |
| | Im a newbie at this stuff, so could someone please post how to alter a table so that i can make a field called numbers to be auto incremented. I dont know how to do this please. The table is called blog. Or can you post how to setup a … Databases mysql  |
| | Example Database id master_id ref_id 1 p1 c1 2 p2 c1 3 c1 c3 4 c3 c1 5 p3 c4 6 p3 c5 Starting with "p1" I wish to return the recursive list of master_id:ref_id Here's the problem: p1:c1 c1:c3 c3:c1 (circular reference) c1:c3 ..... ..... etc How do I … Databases mssql |
| | I have a column "ID" in a table, and I need to move that to another table in the same database. How do I do this? Databases mysql |
| | hi i have an existing table . i'm working with sql management studio. how can i change columns properties ? set column as idenity true. set column as indexable. |
| | We are working on a project & finding an issue while accessing the data from SQL Server. Problem: Display of record in search console of application on number of times it has been processed. Consider we have a record which needs to be displayed 5 times a day in search … Databases client-server mssql sql |
| | Hi all, I'm creating an appointments scheduling system. I have a bookings table and a time table among others in a MySQL database. Each entry in the bookings table has a slotId value. In the time table each slotId has a startTime and an endTime. This is what i want … Databases mysql |
| | Hi, I have created DB applications using MS-SQL and VB. But, I am new for distributed database program development. Will you please help to design one? Databases database-design mssql |
| | Hi all, I have a very simple query but this is driving me nuts. I have installed sql server 2008 on my system. Its working fine, but the main thing is that i am not able to configure the report server. Can anyone help me how to configure the report … Databases mssql |
| | If anyone can point me in the right direction I would greatly appreciate it. I am making an Asset Management database. I'm looking at having about 50 fields in a table. Of those 50, 25 could potentially be used for searching. In some cases multiple fields would be used to … Databases microsoft-access |
| | Hi, lets say I have the following 7 records in my database ID Model -- ------ 1 400 2 400FL 3 400 FL 4 ABC 5 SGH500 6 SGH-500 7 SGH 500 How is it possible if i could select out the rows which are of possible match to some … Databases mssql |
| | Hi Friends, In the website in which i am developing for every searches made an entry would be made in a table. As a result of this the size of the table grows to great extend. Now i am planning to take the backup of that table periodically and to … Databases mysql |
| | Hi, I have an ms-access database (.mdb) which I need to import to mysql. Is there a free software to make a .sql dump of this ms-access database? I have been trying some softwares (google searched) but none of them worked. One of them was able to replicate the table … Databases mysql |
| | Hi all. I have a table with a this records: [CODE] <!-- Table user_activity --> <user_activity> <id>1</id> <event>LOGIN</event> <username>user@domain.com</username> <domain>domain.com</domain> <remote_address>ip_address</remote_address> <date>2008-05-23 20:19:36</date> <comments></comments> </user_activity> [/CODE] I am trying to query the DB to get the total results of activity PER DAY. This is my query (which obviously doesn't work): … Databases mysql |
| | Hello. I have a php script that is pulling records from a database. Everything up until now has been working great. Even now the first page of results show up as they should. (5 records are displayed per page) When I click on "next page" to view more results I … Databases mysql  |
| | hello i have the following code [COde=php]<?php mysql_connect("localhost", "lekan", "") or die(mysql_error()); echo "connected to database"; mysql_select_db("today") or die(mysql_error()); echo "Connected to database<br>"; $tables=mysql_list_tables("today"); if ($tables ==""){ echo "this database does not have a table"; exit; }else { echo $tables; } //number of rows $row_num = mysql_num_rows('first name'); if (!$row_num){ … Databases mysql |
 | I am working on a project that requires a MySQL database to store important information (So a little security would be nice). I realize that some users can't find or don't have MySQL databases with their hosting accounts. I would like to provide users with the ability to get a … Databases mysql |
| | Hi guys, I want to select records from the database, i need to pass start index and end index, then the result set will include those records. Let say my database table has 100 records, i want to get the records between 30-50. How can i do that? Databases sql |
| | hello! How can I display if the query results more than one value? For example, how can I do a query that produces all pairs of salespeople who are living in the same city. Thanks in advance. Databases oracle |
| | Hello! I've beat my head crazy trying to figure out what the heck is wrong with this query. It is not my query, but one from a packaged software I need to customize. I've created a link to the sql db's in an access db (linked to all sql tables) … Databases mssql |
| | Help Please! I am trying to create a maintenance plan in sql 2005 server. I am getting an error Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI) I am unable to create maintenance plan. I am on sp2, and applied a critical hotfix from the microsoft website. I thought maybe it was client tools, but isn't … Databases client-server mssql sql windows-server |
| | |
| | I have created two table valued multi-statement functions using SQL Server 2000 and am now trying to develop a VB.NET front end application where I run the functions and pass string parameters to them. Below is a code fragment for one of the functions. [code="SQL"] CREATE FUNCTION ViewCustomers(@Region varchar(6)) returns … |
The End.