7,494 Archived Topics
Remove Filter  | |
 | Good Day All I have SQL 200 and a SQL 2008 in one Machine. At First there was SQL 2000 and i install SQL 2008. Now we have a ilog Application written in C++. am not sure what that developer uses to connect to the SQL. Now the Application can … |
| | The Paradigm I recently was finally given a computer for work, which runs on Windows XP. I had previously been working using my personal Linux laptop, and had developed several MySQL/PHP applications to aid in data entry and SQL reporting, all of which ran on localhost. I use an "include" … Databases mysql |
| | i am doing a computer project.One part is to propose different functions of a sportsday system, one is to arrange lane for different event. but i don't know how to do it. please help! Databases |
| | Hi, please I need a query that performs the following: I have a table like this: set_id | rec_id 10 | 1 10 | 25 10 | 32 20 | 61 20 | 90 30 | 77 Now I have suppose rec_id = 61 and rec_id = 90 I need … |
| | I am trying to figure out how to set up a form in Access to automatically fill in 2 fields (Region # and Store Name) based on the Store number which is entered in another field. So whenever a user types in a store number, the store name and region … Databases microsoft-access |
| | I've only written one stored procedure in the past and I'm being tasked again to write another one. The purpose of this SP is to do a bulk insert from a .txt file and then to move the file to an "archive" when it's done with the bulk insert. The … Databases mssql |
| | Hello, I have an append query in my access, that is linked with sql server 2005. I want to use an append query that I maked in access, i want to use it in sql server so it can append the records to a specific table. My query is as …  |
| | Hello I'm having a problem to calculate the sum of digits from a field. Example: 1234 I want to sum 1+2+3+4, in order to obtain the result 10. Using the following query I obtain the result, but only by mere coincidence: SELECT model, CONVERT (NUMERIC(6,0), SUBSTRING(model,1,1)*1.0+SUBSTRING(model,2,1)*1.0+SUBSTRING(model,3,1)*1.0+SUBSTRING(model,4,1)*1.0) FROM product The column … Databases mssql |
| | I need the query which will fetch the data from DATE_TIME1 to DATE_TIME2 with interval of 2min or 3 min or 15 min which is variable. The DATE_TIME data is available in the table in the interval of 1 min. ex in the table: 29-Aug-2009 10:00:00 29-Aug-2009 10:01:00 29-Aug-2009 10:02:00 … Databases mssql |
| | Hi, I don't know whether i'm posting this thread in the right forum category or not... But, would you guys give me an info on how we could estimate the cost or budget required to migrate all the data from DB ABC to DB XYZ? Thanks in advance. Databases |
| | I am having a problem restoring my clients MSSQL database onto my desktop using Enterprise Manager. Apparently the database itself contains information about where the original database was backed up from & irrespective of what alterations I make in Enterprise Manager the restore fails. Is there some other program I … Databases mssql |
| | Hello, I am importing a .csv file in mysql. I am facing problem when it comes to date. Let me elaborate. CaptureDate 20071101 20071101 20071101 20071101 20071101 This is data. But when i Load the file, it displays only last record correctly but not the rest 4. Please help. Thanks … Databases mysql |
| | |
| | Hello - I'm just looking for some feedback and some discussion from other DB pros about the viability of a DB design I came up with. The goal is to create the DB back end to an application feature that keeps track of company name history in the event of … Databases |
| | How to set the default value of an attribute to the value of another attribute in another table using Visual Database Tools? Databases mssql |
| | Hi Everyone, I have one doubt in oracle view.. How to pass the parameter oracle view.please help me Databases oracle |
| | this open source thing I am using uses typical contains formsof inflections. I will post the exact syntax if you want. However, it does not do partial word search. How do I incorporate wild-card search with contains formsof inflections? Databases mssql open-source |
| | I want to create a procedure which takes one input parameter(@name) and list all the fully or partially matching results. I used [code=sql]Select * from Table1 Where Name LIKE @Name[/code] but it didnt work. Can you help plz? Databases mssql |
| | How can I add a check constraint to make sure that a date is equal to Today or within the last year and another check constraint to ensure that dateA is equal to dateB or earlier by a maximum of 3 days ? Databases mssql |
| | Hello all. I want to add the mysql to ODBC sources. Im currently running windows vista, and in the control panel, Data Sources (ODBC) when i try to add a system Dns as source i cant find mysql in the list. Here is a pic(so you dont spam [url]http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-windows.html#connector-odbc-configuration-dsn-windows-5-1[/url] or … Databases dns mysql windows-vista |
| | So, i'm working on VB.NET application but I'm having problem with one MSSQL query. [CODE]SELECT ISNULL(Sezona.NogSezona, '') FROM Trener LEFT JOIN Licenca ON Trener.BrTrenerskeIskaznice = Licenca.BrTrenerskeIskaznice LEFT JOIN Sezona ON Sezona.IDSezona = Licenca.IDSezona AND Licenca.IDSezona=3[/CODE] This is the code I've been using 'til now, but it's not working as I … |
| | [code]$sql = "SELECT * FROM schedule ". "WHERE CurriID ON (SELECT CurriID FROM curriculum ". "WHERE (Pre_Requisite LIKE (SELECT CONCAT('%',SubjCode) ". "FROM studgrade WHERE (Grade >=1 and Grade <=3) AND StudentNumber='$id') ". "AND Pre_Requisite LIKE (SELECT CONCAT(SubjCode,'%') FROM studgrade WHERE ". "(Grade !='5' and Grade !='INC') AND StudentNumber='$id')) OR Pre_Requisite … Databases mysql |
| | Hi All, Re-doing a giant, old, crusty sp. So here's a questions for all of you. I have two temp tables: #temp_acct_codes and #temp_hour_tracker. #temp_acct_codes contains these two columns in addition to a slew of others: week, hours, date_worked. #temp_hour_tracker contains week, hours_already_worked, 1_0_hrs, 1_5_hrs, 2_0_hrs, diff_hrs, eper_hrs, loc (different … Databases mssql |
| | Hi all, I want to find out logging ability of mysql when modification is high. In other words, to find out if mysql has an in-built feature to support bulk updates, while monitoring or logging individual record updates. Our aim is to improve performance of bulk updates while logging individual … Databases mysql |
| | hi guys I want know that whether is it possible that to implement Client - Server architecture by using SQL SERVER 2005 EXPRESS EDITION as a main server and on other client PCs also I have SQL SERVER 2005 EXPRESS EDITION . So can i connect to main server from … Databases client-server mssql sql |
| | Hello, I have a problem and I hope someone could help me with this. I have a student registration database. The case is that there is courses that student can register in. And when they register there a groups formed for the courses. So there may be 2 groups that … Databases microsoft microsoft-access |
| | Hello all. I have a small problem with sql. I have a table that has name and rank. For example the ranks would be getted like : select name,score from scores order by score desc So the first line i would see would be person with rank 1, second line … Databases mysql |
| | Hi expert, I'm facing a problem when i try to update the database, below is my code: Dim conn As New OleDb.OleDbConnection Dim strSQL As OleDb.OleDbCommand Dim ra As Integer Dim num conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=C:\employee.mdb" conn.Open() strSQL = New OleDb.OleDbCommand("Update [emp] Set e_name = '" & … |
 | I am working with a third party program that sends data and files to a web based repository for our customers. I have rewritten the ASP side of things and cleaned that up but we have run across a problem. The internal (3rd party) software when sending files to the … Databases mssql |
| | Hi Im trying to execute a the following query, but its throwing me an error [code]select apex_item.checkbox(1,"EQUIPMENT_ID") Tick, ef.equipment_type as "Device Type", e.equipment_name as "Device Name", ef.equipment_id, ef.Customer_Name as "Customer Name", ef.Site_Name as "Site Name", ef.Managed_Ip as "IP Address", dst.discovery_state_name as "Discover State", d.Error_Code as "Error Code" , d.Last_Discovery_Time as … |
| | I am using the SQL 2005 Express edition for SQL server. The database resides on another server and I connect to it from my machine through the object explorer. I have created a trigger to run certain queries and updates, but can't seem to find the trigger listed under [QUOTE]MyDB->Programmability->Database … |
| | Hi, can anyone please rewrite the following sql-query? It's working, but it takes some time to execute. [CODE=sql] SELECT `cd_e_calls`.`bedrijfs_id` AS gegevens_id, `gebeld` , `status` FROM `cd_e_calls` , `cd_e_gegevens` , `cd_e_negatief` WHERE `cd_e_gegevens`.`RvV` != '1' AND `bedrijfs_id` = ( SELECT `cd_e_gegevens`.`id` AS gegevens_id FROM `cd_e_gegevens` WHERE ( SELECT COUNT( `cd_e_calls`.`bedrijfs_id` … |
| | I am trying to copy a list of email addresses in Excel and paste them into SQL. I am using Navicat. I am able to paste the text, but I lose the hyperlink format. What can I do? Obviously, I new at this. Any help would be appreciated. Thanks...Gadfly_1943  |
| | Hi All! I am working with an MSSQL DB which stores images as blob's. When I pull out the blob it seems to be cut off at a fixed length. Every image only displays the top 1/3 or so. My query is very basic and has no limitations in it … Databases mssql |
| | I want to create a procedure to update a table. It takes number of input parameters(one of them is the @pID) and updates four columns which have the pID=@pID and only one of these four columns can be updated if the value of another column='F' in addition to pID=@pID. How … Databases mssql |
| | Hi Im rubbish MySQL joins, and need an assist please. i have a product table and an images table. Each product has 4 images associated to it by a foreign key product id in the images table. I need to pull out the product info (from prod table) and 1 … Databases mysql |
| | I have been reading up quite a bit on the topic of Stored Procedures (SPs) and keep coming across contradicting opinions from various 'SQL experts' on whether or not they should be used. Sometimes it's a downright 'No' ([I]Frans Bouma's[/I] Blog for example -- google the term for the article), … Databases mssql |
| | Hi everone, i have a table containing employees in and out dates of a project containing sat and sun.i want to remove sat and sun and display results.how to achieve this. Databases microsoft-access |
| | Hi I need to generate a CSV of names and address from a table and I would like only one result (it doesn't matter which) per distinct email address. If possible, they also need to be ordered by DateAdded descending so I can select just the most recent 1000 results. … |
| | Hi I have three MS SQL 2000 Servers distributed as follows: (img Server 1: Name: JBCB_SRV1 OS: Windows 2003 SE DB: MS SQL 2000 Server SE MS SQL Replication: Publisher Source DB: Northwind Server 2: Name: WEB OS: Windows 2000 Server SE DB: MS SQL 2000 Server SE MS SQL … Databases mssql web-server |
 | Is there a way to isolate the nth record from a table using [U]sql queries alone[/U]? The table is a [U]non relational[/U] one and you cannot use any temporary tables...Do u think there is a possible solution for this in MS SQL Server 2000? Otherwise tell me whatever you know? … Databases first-post mssql sql |
| | Hello everyones, I want to delete where my id has unique identifier in the table in my database.... how can I do it? Thanks |
| | I need to create a table to store matched pairs that I can query and get a count of how many times a particular matchup was entered. For example "5" might be paired with "6", but "6" might be also paired with "5". (Quotes are for clarity - not to … Databases mssql |
 | Hello all, I want to create a custom login form for SQL Server 2005, which will have 2 textboxes(Username,Password). When the users clicks the submit button then i want to check the SQL Server users with that username and password,if exist. I need this to be answered asap! Thanks in … Databases mssql |
| | Hi, First I wish to say that I have tried my best to think, but I still coudn't think "out of box". I want to perform a SQL statement base on the condition below: 1.) Table A consists of employee data (Emp_Id, Email, Sex, Address, race and nationality) We have … Databases sql  |
| | Hi All, Could anyone suggest us how to check the Time in the Database when an Order get injected into the Oracle data base as of now i am able to see only the date , but inorder to know the time when i got generated can anyone help me? … Databases oracle |
| | Dear everybody hope someone can help me!! Im trying to SUM data from 2 different tabels without any ID connection between and I what to subtract the results from eachother afterwards.. how do i do that. lets say i have tabel1.costs and tabel2.profit I would like to SUM the data … Databases mssql |
| | hi. i have to print the time table in database .. like rows and columns. for example like this 1 2 3 4 mon tue wed thu fri sat so ,how to write the query and how to insert the rows and columns .can u tell me the answer.. Databases mssql |
| | hi, i need to print the last row of the table in the data grid form .i am using the sql server and c#.net.. i want to print the recently inserted row of the table.. can u tell me the answer.. Databases mssql |
| | Hi, I have a table which I want to update thus: If d_date is has a value and b_date is 30 or more then set d_date as the min value already in d_date. I know that the WHERE EXISTS clause is wrong but I don't know how to make this … Databases oracle |
The End.