Here is the print out if I set debug=1. I looked at the execute plan. It is two table scan costly.

One is here since it need to scan the table...

but this is one scary, too. it gave me error.

Thx.

the stored compiled , but it gave error while I run it. I declared it in the first name.

Thx. it has results , but the results are not my expected. but the BILLINGHC is not append . I looked at my function is nothing different from the example.

SET...

SELECT TOP 0

  PNO,

  MIN_PCT = MIN(CPTCODE),

  CONCAT = DBO.UDF_CONCAT_CPT(PNO, MIN(CPTCODE))

INTO #RESULTS

FROM PNO_CPTCODES

GROUP BY

  PNO

I do not...

Pete:

You can post the code here, so that other people would benefit. I pm you my email address , too.

Thx.

Frances

Theory wise, it will work but it still take more than one hour's hr. I think   .. Thx you for your time.

one time deal , but right now it has been running more than 1.45 hr. I have more than 15,000 records with different number.

I have more than 20,000 records. The method would not work. I ran the procedure. It took more than forty five minutes, it is still running.

Thx. I changed the as

if (SELECT     COUNT(*)

FROM        inserted INNER JOIN

                      tblInternalEduModule ON [inserted].[Quiz Name] = tblInternalEduModule.Quiz

WHERE     (tblInternalEduModule.Category = 'WIN') ) >0 . it work fine right n ow....

Yes. I check all the data no null data in the column and I check the where . it is OK.

I do not understand your union statement.

92 010018200 Back Injury Prevention                             5 460

95 010018200 Corporate Compliance                               8 760

94 010018200 Ethics                                             5 470

92 010018200 Event Reporting                                    5 460

97 010018200 HIPAA Privacy                                      7 680

94 010018200 HIPAA Security                                     9 850

98 010018200 Infection Control                                  6 590

96 010018200 Mission Integration                                6 580

90 010018200 Quality Improvement                                8 720

96 010018200 Safety                                             6 580

90 010018200 Sharps Injury Prevention                           2 180

91 010018200 Slips and...

.

hard to comprehend you demo

NULLABLE is allowable. but all the data would be on the column.

After I changed the result became:

SELECT   distinct AVG(CAST(SUBSTRING(A.Score, 1, len(A.Score) - 1) AS int))  AS AvgScore, HREMP.CC, A.[Quiz Name]

FROM       (select * from  [Quiz Log] where ([Quiz Log].Score <> 'Waived')...