7,494 Archived Topics
Remove Filter  | |
| | |
| | Hi Expert, Guys, i need your help on how to do a script calculating the totalDays using the formula (see below). i have to calculate the totaldays based on different Supplier and Rtype and also if the totalday is less than the warranty period i have to indicate it as … Databases mssql |
| | I am trying to connect to crystal report from Visual Studio 2010 but i realised my SQL database should have SQL authentication (i.e requires user and password) instead of windows (which was assigned by default). I have tried several approaches to achieve this without luck. Will appreciate some help. Databases asp mssql sql visual-studio |
| | I have written an SQL query to return the total quantity of products ordered and total price. The query returns a result for each order in the range I have specified.Please find attached the output i am getting. the desired output i want is as follows: (year,productcode, productname, orders, quantity, … |
 | Hi In my office there is an application ,and database is Sql server 2000.Using ODBC connection application connect to database.Recently database move into sql server 2005.Now application is not working,Its generate error message error message is "Connection failed".I tested the ODBC connection its okay. *I dont know what is language … Databases mssql |
| | After installing xampp, when i try to stop mysql and apache for restart it does not start.It gives error: mysql can not be stopped.Busy!Please help. |
| | Hi all, I like to rename my table's column. My table name is: utf8_Alter Field: Branch In the Branch field I have few columns name I tried to change the name with this query: But it didn't work. [CODE] ALTER TABLE `utf8_Alter` CHANGE `ゴルダーズグリーン` `ーン ノースロンドン` varchar( 64 ) MySQL … Databases mysql |
| | Hi, As the title states, I have a query that I use to concatenate all the rows into a single string and I use the XMLTransform method to accomplish that but I still need to add a new line separator within the XML string and so far I didn't find … |
| | Greetings, I am doing a project that will migrate sybase central to oracle with the used of oracle sql developer, and when im trying to add new connection in sql developer that will connect my sybase when i try the TEST button its status is success but when i retrieving … Databases oracle |
| | hi, since i have shifted my host these weird characters showed up on website! "ââ" i checked database, they are as it is written there. so when i call something through query they showed up too makes it worse, removing them manually is quite difficult. so please if anyone could … Databases mysql |
| | Hello everyone, I have to query a table according to the current item being fetched in the select statement. What I meant, I want to form the name of the table and query it on runtime. For example, there is an item that comes from items table and it has … Databases mysql  |
| | Hi I have a table storing time-sheet data, including a start & end time. I've set those fields as 'TIME' format, and tried doing the following calculation [code] SELECT SUM(log_end - log_start) AS timetotal FROM time_logs WHERE log_client = 'ECDC' [/code] It returned an integer, which doesn't correspond with any … Databases mysql |
| | Hi there, My knowledge on query optimization ends here. I am stuck! My table with following structure has more than 1 million records. CREATE TABLE `dreambank`.`db_ip_data_buffer` ( `ip_from` bigint(20) unsigned NOT NULL default '0', `ip_to` bigint(20) unsigned NOT NULL default '0', `country_code` varchar(2) default NULL, `country_name` varchar(64) default NULL, `region_name` … Databases mysql |
| | I have a monthly fee collecting table. I need to store year and month only for that purpose. For example just like to store, John has done the payment for 2010 July. I thought of using a DATE field for this. I can store the year and month with valid … Databases |
| | Update spot_price set location = ‘PATAN’ where symbol = ‘CASTORP’ and polling_date between ‘20110730’ and ‘20110806’ Giving sql syntax error. Same query i am using to update another table in sqlserver its working but not in mysql Databases mysql |
| | I'm thinking a databases that have scheduled time and date and if the computer time have been match to the scheduled time on the databases the other computer will be automatically shutdown Databases mysql |
| | I'm missing something stupid so I need another set of eyes. I have a session value set that's a group concat of a few ids and I want to check to see if an id found by a query is in that group concat. The group concat variable is $session_unitidgrouping … |
| | hi, looking for some tips, using dreamweaver as my tool and wondering if someone could help. i basically have 2 tables. 1 which is partsused and the other stocklevels. the stocklevels contains stock details and also if it is in the van or unit. on my page i have an … Databases mysql |
| | hello...i just installed oracle 10g in my pc but i dint get username and password for sql*plus......plz help me |
| | [CODE] insert into AUDIT_TABLE( "TIMESTAMP", AUDITCATEGORY, USERID, AUDIT_XML, "AUDITID", "SOURCE", "ROLE", EVENT_ID, EVENT_DATA, TYPE_OF_APPLICATION) select CURRENT_TIMESTAMP, AUDITCATEGORY, USERID, AUDIT_XML, (SELECT MAX(AUDITID)+1 FROM AUDIT_TABLE), dummyNumber||i, "ROLE", EVENT_ID, EVENT_DATA, TYPE_OF_APPLICATION from AUDIT_TABLE where "SOURCE"='1312171509321'; [/CODE] Hi, Above is a part of my stored procedure , I'm trying to create test data for … Databases oracle |
| | create or replace [CODE]PACKAGE BODY employee_details AS PROCEDURE INSERT_ROW ( P_EMPNO IN NUMBER , P_ENAME IN VARCHAR2 , P_MGR IN VARCHAR2 , P_SAL IN NUMBER, P_DEPTNO IN NUMBER, P_COMM IN NUMBER, P_HIREDATE IN VARCHAR2, P_JOB IN VARCHAR2, P_error_message OUT VARCHAR2 ) is l_EMPNO NUMBER; l_object_name VARCHAR2(60) := 'employee_details.INSERT_ROW'; BEGIN te_trace('Entered … Databases oracle |
| | it is highly recommended........that tell me exact difference between storedprocedure and trigger Databases oracle |
| | Hi, how can we reduce the time of query execution time? I m using mysql. I have to execute one query which select data from lot of tables . It takes more time to execute. Please give me good suggestion for this....... Databases mysql |
| | I was asked a question a few days ago that I cannot easily answer. "Why don't we put all of our small application databases into a single database?" Well, There's nothing really stopping us. All of our small apps were developed in house so we don't have any problems with … Databases mssql  |
| | the following gets first date of the week [CODE]DECLARE @Year SMALLINT = 2011 ;WITH cteSource(firstdate) AS ( SELECT CONVERT(varchar(50), DATEADD(DAY, 7 * v.Number, o.Origin), 101) AS firstdate FROM ( SELECT DATEADD(DAY, DATEDIFF(DAY, '18991230', STR(@Year, 4, 0) + '0101') / 7 * 7, '18991230') ) AS o(origin) INNER JOIN master.dbo.spt_values AS … Databases mssql  |
| | [CODE] set datefirst 6 datepart(wk,'2011-01-12') [/CODE] yields 2. I would like to derive 2011-01-08 from this number. please help.thanks in advance. Databases mssql |
| | I restart a project of mine which use mysql, I used xampp in the past to test the code on the mysql server so I update to lasted version but a piece of code that is identical and was working, I now get an error in [U]the class check in … Databases mysql |
 | I hope I can explain this. I have a table which contains a field named ID. This is set as PRIMARY. Because users registered on my site and after that deleted their accounts (so a lot of rows got deleted, too) the table rows now are jumping, for example, from … Databases mysql |
| | I'm connecting to the DB with LibreOffice Base, and initially forgot that this [I]isn't[/I] a MySQL db [COLOR=SlateGray](it's our only non-mysql db)[/COLOR], so I have to say thanks to those from the other forum who helped get me started when I mis-posted. Anyhow, here's what I've got: [CODE]SELECT DISTINCT c.primaryemailaddress, … Databases mssql |
 | Q--> i have a [U]employee[/U] table which cantain following field (eid,enm,salry,did) and i need a list which has employeies complete information whose get minimum saler in each department *** only single list cantain all employee info whose get minimum salry Databases microsoft-access |
| | Hi all, Batchdate comes in as string format (07/07/2011). I tried but for some reason am not getting any results. Any ideas? [CODE]ALTER PROCEDURE dbo.CouponReportbyScheme ( @BatchDate varchar(20) ) AS declare @myDate datetime select @myDate = convert( datetime, @BatchDate) Select * from Coupons where CouponGenerationDate=@myDate [/CODE] Databases mssql  |
| | I'm trying to populate a temp table, and I'm getting this error [INDENT][COLOR="Red"]Msg 8152, Level 16, State 14, Line 1 String or binary data would be truncated. The statement has been terminated.[/COLOR][/INDENT] Hmmmm ... here's what I'm trying. I created two temp tables and populated #emails from a spreadsheet (text … Databases mssql |
| | Hello! please i need help with this,after sumiting my form i get this error message on line 111 any help i will appreciate, thx [CODE]<?php session_start(); include("../Connections/recruit.php"); echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; //check certification $certification = $HTTP_POST_VARS['certification']; if($certification != "accept") { echo(" Your application has been terminated as a result of … |
| | I have the following code. [CODE]$result = mysql_query("SELECT * FROM topics LEFT JOIN quiz ON topics.managerId = quiz.managerId WHERE quiz.userId = '$userId' AND userId= '$userId' AND $egroup = 1 GROUP BY topics.title")or die(mysql_error()); while ($row = mysql_fetch_array($result)){ echo "{$row['quizId']} <br />\n"; echo "{$row['title']} <br />\n"; echo "{$row['passState']} <br />\n"; } … |
| | I was wondering if anyone could point me what coding feature I'm talking about that can fulfill this role. - So I need to update data values from many users at the same time at a specific X amounts of time or specific hours of the day. What programing process … Databases mysql |
| | Hi, Hoping someone can help with a query I'm stuck on. I've got a field (sm_contact1number) containing phone numbers. Some of the data has been imported via Excel and its stripped some of the 0's out of the start of telephone numbers, so 0121 3324234 now looks like 121 3324234.. … Databases mysql |
| | I need some help regarding pagination. whenever i searched for a record, the pagination doesnt work but it still show the results. here are my codes index.php [CODE] <html> <head> <title>Paginating Your Data with AJAX and Awesome PHP Pagination Class</title> <form action="index.php" method="post" name="searchdb" id="searchdb"> <table> <tr> <td><tr> <input type="text" … Databases html-css javascript-jquery php |
| | Hi, When a SELECT query is executed does MySQL store the resultset in some table? If it does, is there a way to find out that table and access it later before the session is closed? thanks, |
| | Hello to all, I have installed SQL Server 2005 on windows xp . Please tell me how can i create new SQL database ?  |
| | I've to design a database for a tuition centre. Here is some business rules for it: - A centre has many student (1-m) - A centre has many teacher (1-m) - A centre offer one or more subjects (1-m) - A teacher teaches one or more subjects and a subject … Databases database-design |
| | Hi Everyone, this my first time. My question is how can I locate a non-ascii character in a string/field? Thanks, C Databases mysql |
 | Hi, I have 20 rows in a table and I want to update 10 of them only. I am using MS SQL. Any ideas please. Cheers Databases mssql |
| | Hello everyone. Please somebody teach me how to setup mysql database. I have register a free domain for social bookmark website. But I found problems when making database. Please teach me step-by-step to create bookmark website database. Ohya, I use Pligg free software for social bookmark site. Thank you before. … Databases mysql |
| | Hi folks I have several JPEG thumbnail images in a database and need to select particular ones, stitch them together and post them into single cell in the table on a website. I've created the following query: [CODE]SELECT s.Set_Code, t.Mimetype, GROUP_CONCAT(t.Image SEPARATOR '< \;>') AS 'Image' FROM Thumbnails t INNER JOIN … |
| | Hi, I have a table with more than 3000 records. I need to replace a particular string of all the rows wid some other string But when i am using replace function Its only replacing half of the rows of the table while the other half are not getting replaced. … Databases mssql |
| | Hi Guys, I have created a manual SSRS Report. when i click the layout tab it display report layout then i drag the fields from report datasets. i want to set my fields into Table details and i want to insert group but this function is missing or hide. i … Databases mssql |
| | |
| | Hi, I want to implement a voting system in my web page. What I want to do is give a user 1 point per day so they can give that point to other users but after they give their point they have to wait until the next day to have … Databases mssql |
 | I have a somewhat complicated select query which returns, in part, the following resultset (as an example): [code=text] threadid views -------- ----- 1 5 1 5 2 10 3 15 4 10 [/code] If I were to do the following select: [code]COUNT (DISTINCT threadid), SUM (DISTINCT views)[/code] then it would … Databases mysql |
| | Hello, I need to create ER + relational models. I've came across Embarcadero Studio Data architect, but I'm having some trouble using it. What's the problem? I want the bottom table (PunctLucruActivitate) IDFirma to be in a relationship with IDFirma from the left table (PunctLucru). It won't let me do … Databases |
The End.