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

Hi ca8msm (Programmer), SQLDenis (Programmer) I have a informationfeedback database of which one of the table contain these fields: ========================================== Quality, timeliness, Needs, Services 10 10 10 NULL 8 9 9 10 9...

I got a sample code from the web, it run perfectly but I realised that my output result was not correct due to presence of a NULL value in a table, hence, I am asking for help on other method use for calculating Percentile if a field contain a null value / zero (0)...

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

I have it saved on my local machine. Actually, it was installed under: Start->Admin Tools > ODBC Data Source, then UserDNS. SQL Server is runninig in different machine (SQL_SERVER). Please help. Thanx. 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...

Thanks for participating in this Forum! it really helps. I have another question: While checking the rest part of my store procedures, again, I have used "WHILE" in below codes: ===================================================== - * Shared Contacts * -- Create ShareGroup which groups any...

The reason I've used WHILE LOOP is to check and test if any row(s) is affected in the tenporary table (#MergeMap) in the first part of my code. I have change "WHILE@@ROWCOUNT > 0" to "IF @@ROWCOUNT > 0" and I can confirmed that it is working. Many thanks. Dan

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...

Thanx Tarwn and DNG. I will let you know as I progress. has anyone check why I my code doesn't update multiple records?. I have already post the question. regards. Dan

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...

ITS NOW WORKING. here is my mistake: "forenames" it should be strForename= Request.Form("forename") MANY THANKS TO YOU ALL!!! Dan

when I used this command "response.write SQL", then I get this result: UPDATE Students SET Surname='Nichola', forename='James', education1='Olevel', education2='none' WHERE StudentID =22222; ============================== When I used "myConn.Execute sql" then I get this error: Error Type...

Still same story. I actually defined constraint on cascasde and on update. however, I've removed the constraint but still give error. Any other style / method of updating records / multiple record?. regards. Dan