Is this post the same as your other post?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=328379

It sounds to me like the same question.  If it is, please do not cross post.  Both of your posts have...

Which table are you updating, the temp table or GE Claim?  How are the two tables related?  Can you be a bit more descriptive as to what you want done?

Just as Sergiy said:

INSERT INTO #tmpTable (you need to define this prior to this statement)

SELECT

    a.PolicyNumber,

    a.TableCode,

    a.SeriesCode,   

    a.LossDate,

    a.EffectiveDate,

    b.WaiverofPremium

FROM tableA a

    INNER JOIN tableB b

    ON a.PolicyNumber...

I would guess that you could interchange the words 'youngest' and 'most inexperienced' and the statement would still ring true.

"by the way im one of the most inexperienced oracle qualified...

Is there a specific problem that you are having?  If so, it would be helpfull if you would post your UDF and provide a description of your problem and include...

What exactly does "This query runs within the above code's looping output" mean?  Does this mean that you've written a cursor?  Please post all of your code, DDL for relevant...

Oops, my bad.  That will not work.  Will your Code values be the same for the employees and only the hours different?  If so use

SELECT Empoyee#, Code, MIN(Hours) FROM...

The only way that I am aware of would be for you to run profiler and capture all incomming traffic.  How busy is your system?  Keep in mind that this...

I suggest you think about re-designing your approach, but if you insist to go down this route, check out these two threads.  The first one in particular should be helpfull.

I think you’re going to have a problem with this solution.  While you may be able to get something that works, it may be best...

Does it need to be sequential or just a random unique numeric?

Can you post the syntax you are using in your connect string for OSQL? 

What is too long?  What index rebuild command are you using, DBCC DBREINDEX?  Consider running DBCC SHOWCONTIG directly after your index rebuild job runs, directly before it runs, and sometime...

I'm not real sure exactly what you are trying to do, but it sounds like a great place for a scalar function.  When you say "I would like to concatenate...

OK, this is a different issue correct?  Look through that same article as it provides alot of SQL mail troubleshooting info.  Your mail configuration may not be setup correctly.