David Poole's query on the SUM and Location of hair is the best!!!!

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=148768

What a shame.  I bet you have missed out on a lot of friendships as well with this kind of baggage.  Too bad...

Glad to help - I too often miss the trees for the forest... 

(fortunately I have 'friends' here who are more than happy to point that out with 'humor'...) 

Yes.  103 is part of the Convert Datetime function:

SELECT *, CONVERT( varchar, CONVERT( datetime, Date_Lst_Iss,103))

FROM dbo.Part_Mast

WHERE Part_Num LIKE '258095GB%'

ORDER BY Part_Num

Does it have to be?   

Erog the ego...  

How does one 'play' (fair or not) with a "brown recluse"?   Byte the...

I see at least one thing.  You are summing rep_comm, but you are also selecting and grouping on this field.  This will throw off your summation as it will treat...

SELECT with  GROUP BY and HAVING COUNT(*) > 1. 

This will give you both records...

I can only guess, (hopefully one of the smarter people on this site will review this as well) but it sounds like a "blocking" issue.  Can you wrap your code...

c'mon David.  We can't take that!  I'm the ONLY bully (bulldozer) here...

OMG!  If he figured out what I am doing wrong, would we be the "Dynamic Duo"? 

Glad to help. 

I am a little lost here. The Trigger on the job works every time, but when the job is run twice, the Trigger runs fine and a new record is...

I'm not paranoid!!  What do you mean by that anyway, SpiderWoman?   

DECLARE @tblCustomer TABLE( CustomerID integer, 

                                             PaymentCount integer)

INSERT INTO @tblCustomer

SELECT 1, NULL UNION ALL

SELECT 2, NULL UNION ALL

SELECT 3, NULL UNION ALL

SELECT 4, NULL UNION ALL

SELECT...