Recent content by 2122002

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