Search results for query: *

I want to have button when end user click. The Find From the menu bar pop up. Thx.

I get a forwarded e-mail that comes as an attached msg file. It is around 1000 message. I need to open the attached msg file and export to excel file. I am oK with export the regular outlook item. but I do not know how to convert the attached msg as normal email message file. I am ok to dump...

If LabOutConnection.State = ConnectionState.Closed Then LabOutConnection.Open() End If Dim sqlStr As String = "select * from NewImportLabChar where Mid([NewImportLabChar]![LabResultString],1,1)='>' or Mid([NewImportLabChar]![LabResultString],1,1)='<' " Dim...

I have excel file which has two columns with the same name. I can't import the file into MS Access. Will you please give me the code to delete one of duplicated column first in MS VBA code so that I can import. Thx.

I have one table module log which have trigger association with that. When I insert into [module log]([Employee Name], [DOB], [Module Name],[Access Module Time], [manager login ID]) SELECT [FULL NAME], DOB ,'Back Injury Competency',getdate(), 'abcl' FROM OcchEmp WHERE (Unit...

I have three tables OcchEmp,tblInternalEduModule, tblCurrentWinTrainingLog I want to get the total employee count in OcchEmp group by unit as Tcount I need to the count employee in tblCurrentWinTrainingLog as count group by module name tblInternalEduModule which category is WIN and group...

Any way to do get the record count of the following query. SELECT distinct h.[Full Name],h.DOB FROM annual_edu_2006.dbo.HREMP h INNER JOIN(SELECT [Employee Name], DOB FROM [Module Log] UNION ALL...

module log Name DOB [Access Module Time] [Module Name] ABC 1/12/02 1/12/07 Help ABC 1/12/02 1/12/07 Help2 ACC 1/12/62 11/12/07 Help2 ACC 1/12/62 12/12/07 Help...

EmplID Status License Verify Expired 11112 OR RN Y 7/17/07 11113 ER DR N 11114 PP DR Y 1/1/07 11115 OO DR 7/1/07 If the end user select 11112, it will return the record 11112 OR RN Y 7/17/07 If the...

SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE dbo.DueListWithPreviousTraining_Temp @quiz VARCHAR( 25 ), @fromdate datetime = NULL, @todate datetime = NULL, @unit nchar(5) = NULL, @cc nvarchar(4000) = NULL, @debug...

I tried to get the recentest training data for employee SELECT distinct EmplNO , QuizName, CTDate FROM tblPreviousWinTrainingLog b WHERE CTDate IN ( SELECT MAX(CTDate) FROM tblPreviousWinTrainingLog a WHERE b.EmplNO = a.EmplNO group by b.QuizName ) Here is my table defination: if exists...

/*. according the due date end user select and ALTER temp table find the nomatch table in the occh and return the table if the end user select the data, then it will show just the empl take the test during the period. otherise including all the empl not take the test. 1. test a.with previous...

according to this : http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true I created my function. create FUNCTION dbo.combine_cptcode (@pid As char(8)) RETURNS varchar(1000) AS BEGIN DECLARE @cptcode AS varchar(1000) SET @cptcode = '' SELECT...

I have the following info. I need to update table OutPatientMedStat from those records PNO CPTCode 40000028 80061 40000028 83735 40000028 84100 40000028 84436 40000028 84443 40000028 84479 40000028 84480 40000028 85025 40000028 86617 40000028 86618 40000027 86617 40000027 86615...

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO ALTER PROCEDURE [dbo].[get_Quiz_log_by_emp_Avg] @DateFrom datetime, @DateTo_in datetime, @strName varchar(26), @dtDOB datetime, @debug bit =0 AS declare @DateTo datetime select @DateTo = @DateTo_in+1 --DECLARE @sql...

whenever thd quiz log has quiz enter which the quiz name in table tblInternalEduModule category is Win add to the tblCurrentWinTrainingLog the trigger did not trigger as expected ? Thx. create trigger CurrentWinInsert on [Quiz Log] for insert as --insert on the win quiz only is win and...

PATIENTID" "PATIENTIDNAME" "BILLINGHC" "BILLINGHCNAME" "CASES" "BILLINGHCPCS" "DISCHARGEDATE" "PRIMARYAPCCODE" "12048583" "aCCcG ,JEAN " " " "NO BILL HCPCS " 1 0 "06/30/2006 " " " "40000002" "aCE ,eiii " " " "NO BILL HCPCS " 1 0 "07/28/2005 " " " "40000069" "EFTOFF ,Rboert " "83615" "LACTATE...

I have one table which the payment from multiple insurance company and another table contain the patient information. I want to update the patient information with the insurance company information who paid the most bill. table one: PID Payor 111 222 333 I need to update the table one with...

I set up the DTS in my server which install smtp mail server. DTS will try to import the text . Before I import , I want to check whether the file is update otherwise I will email operator to update. if update it, then import. On the workflow , i added this active script. The mail part is not...

I have two queries I want to combine together to get the JobCCNO, TotolEmpCount, TotalCompleteCount, IncompletedCount For IncompletedCount should be TotolEmpCount-TotalCompleteCount The data should be extract from tables OcchEmp,The data should be extract from table...