Search results for query: *

Dear Expert, I have a table which was delivered by a customer and is being messed up. What I want to do is to move/shift data/ROW/Column from one to another within the same Table. Data in the table was initially converted from EXCEL to MS-Access and column heading is inside the recordsets...

Dear Expert, I have a table which was delivered by a customer and is being messed up. What I want to do is to move/shift data/ROW/Column from one to another within the same Table. Data in the table was initially converted from EXCEL to MS-Access and column heading is inside the recordsets...

Dear Expert, Does anyone has/know VBA code to Auto generate either a Table or field in MS-Access or in SQL Server (or both)?. Thank you. Dan

Dear Experts, HELP, HELP, HELp PLEASE!!! Does any know / have a code to calculate 75 or 25 percentile even if one of the value in the table is NULL?. Thank you. Dan

Dear Expert, I have created a DTS package that export data through ODBC (DNS, with user name and password ) connection from customer server to my SQL Server 2000 machine. Source: ODBC Connection (DNS) with username and password permanently saved. Destination: SQL Server (local) This works...

Dear Experts, Below store procedure (code extracted) keep running and takes more than 2 hours, and never terminated: Can some please have a look and guide me through whatever I am doing wrong. I have approx 750,000 records on tables "tblMergedPatients" and approx 68,000 in table...

Dear all, Can some please help me to walkthrough on writing a code/ActiveX/.NET script for sending a flat file to a client FTP site. I had used drag & drop SSIS FTP, but it sometimes fails; if there's a large file, it never deliver the file to client's FTP site. HELP PLEASE!!!. Dan

Dear MS-Access Experts, I have a production(application using MS-Access VBA/Tables/Queries e.t.c) to be produce on CD and be deliver to end users, however, most of the end-user may not have Microsoft Office and or MS-Access installed on their PC's. How/what advice will give me on how to...

I have a Form called "StaffList.asp" and another one is call "Entitlement.asp". Stafflist.asp have this input value (as password field). <TD ALIGN=CENTER><INPUT TYPE=PASSWORD NAME="Enrolment"> Entitlement.asp supposed to carry out SQL search based on the input value from "enrolment" field...

Dear All, I have been surffering to update multiple records in a table/database. Below is my code, when executed, I got the message "Record Save" however, if I check my table "PaySelection" record never updates. Please help, I new to ASP codes. ==============================================...

My idea is to check if login file is open or not whenever user loads a page. For example, I have "payroll.asp" file, this file should first check if user has already login or bypass login script. If login page is not loaded then the user should be redirect to "login.asp" to enter username and...

Dear All, Ive been battling with below codes. All I want is to update the "Student" table ni MS-Access. I use DNS-less connectoin. the error i keep getting "Too few parameters. Expected 2" error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft...

Dear All, I have been struglling to connect to my database (inventory.mdb) located on "Stock\Admin\inventory.mdb" direcotry. I have two folders "Admin" and "User". I do not have problem when I run "defaul_adm.asp" under the Admin folder where the .mdb is located, however, if i tried to run...

Dear all, When I bootup my machine (Win XP Prof) with LAN cable connected to it/connected to the Server (Win 2003 server) and if I try to run SQL+/DBA Studio then I receive Error message " Oracle not Available". When I bootup my machine without LAN cable connected ot it, then it work. Have I...

Please check if below Normalisation is correct, also advice where to improve and reasons for an improvement. FDs and thier meaning to be Normalized: exam_date: the date on which the exam session was held exam_name: Name of exam to be taken StudNo: Identify'n Nos of student exam_time: Time...

Dear all, here are the few questions: 1) What SQL*Plus command can I use to list all available tables in the Oracle directory (or when I logged into Student directory) 2) I created a VIEW file called StudAdmssion2006. What SQL Command can I use to print out all tables involved in my view...

Hi all, I have a field name "DonDate" with this date format MM/DD/YYYY HH:MI:SS AM. Example: Name | Sex | DonDate --------------------- James |M | 08/08/2005 Juliet |F | 03/02/2004 Good |M | 01/01/2005 Armand |M | 09/09/2005 How do I know list of people who have...

I have 3 tables: Person, Patient and Donor. Person Table contains: Pno | Name | Sex | ABO ---------------------------------- 101 | David | Male | AB 102 | Williams | Female | O 113 | Smithy | Male | A 112 | Cinthia | Female | A Patient Table contains: Pno...

Hi All, I have a table called DUMMY with the following fields and record: DONDATE | USAGE | PACKETNO -------------------------------- 03/08/2005 | Yes | AB009 08/06/2004 | Yes | AA112 07/05/2005 | | HJ112 What I want my query to do is to: Retrieve the year (possible...

Dear All, I installed Oracle on my Laptop 1 1/2 months ago but ive not used it for a while, I have now forgotten the username/password to Oracle DBA studio. what should I do to recover my username+password without re-installing Oracle 8i again.? I have tried below command but it did not work...