I do not know why any activities in the sql server is slow. connected to the sql enterprise manager. run the query. open the table, design the table...

Thx.

Thanks. I use space as delimite and text qualifiler as ". it solved the problem.

it is not tab. While I tried to open as tab in excel and it also have more than 65538 record. excel will not open properly, too. Between " "....

Thank you poiniting out.  I looked at the code. Right now I understand why.

Here is my version according to the other posters.

UPDATE InpatientMedStat

SET InpatientMedStat.InsurancePlanCode = t2.Payor

FROM InpatientMedStat ims

JOIN (SELECT ...

I know these two (Aaron Ingold&nbspand Ronald San...

UPDATE InpatientMedStat

SET InpatientMedStat.InsurancePlanCode = t2.Payor

FROM InpatientMedStat ims

JOIN (SELECT Distinct rptPXA3.PNO, rptPXA3.Payor, rptPXA3.Payment

FROM rptPXA3 t2_1

JOIN (SELECT PNO, MAX(Payment ) AS MaxPayAmount

FROM rptPXA3

GROUP BY PNO

) t2_max

ON t2_1.PNO = t2_max.PNO

AND t2_1.Payment = t2_max.MaxPayAmount

)...

Thanks.

I do not what you imply here " why are you using dynamic SQL?  "

Since I need to extract the fields from five tables and export the table out...

I looked up the bol. What min(name) here do ?

SELECT @procname = min(name)

FROM sysobjects

WHERE xtype='P' and name > @procname and name not like 'dt_%'

Thanks.

I want to get my certification in MCDBA, too. If I prepare SQl2000, by the time, I finish all the test. It will be late 2007. I think at 2008...

Thanks. I changed my ip address to what i used in the web application our exchange server ip address. it worked. but I got my smtp ip address from iis...

Function   EmailNotify()

        Dim myMail  

    Set myMail=CreateObject("CDO.Message")

    myMail.Subject="DoctorMasterUpdateReport"

    myMail.From="abc@Abc.com"

    myMail.To= "abc@Abc.com"

    myMail.TextBody="Doctor Master is not update, " & Chr(13) & Chr(13) _

    & "Make Sure to Delimit Lines"...

Will you please give me the code for vbscript ? I modified my stored procedure and it gave me the error for 'Configuration Object. i think it must be...

According to your post, 228 is for MS sQL 2000. Microsoft will not support SQL 2000 in 2008. So it seem no point to take the test.

Thanks. Do you know any the good web site for scheduling ?