SELECT *

INTO #temp

FROM( SELECT CONVERT( varchar, CONVERT( datetime, Date_Lst_Iss, 103)), Part_Num

           FROM dbo.Part_Mast

           WHERE Part_Num LIKE( RTRIM( '258095GB') + '%'))

Thank God, Sushila!  I am so tired of my 'simple' html screwing up.... (or is this just another trap    ) 

Don't get me wrong Kenneth - you were absolutely correct! (as was the poster not copying in 30 pages).  It just struck me as hilarious! 

Not knowing exactly what the Trigger is doing - can you check for existence, (it sounds as if the Trigger is altering data as well as sending an error/alert) before...

Excellent point! 

I have seen too many applications in which this overlooked! (Often the data is checked at the front-end and the user gets an error they cannot understand if...

Oh..., those "alluring" traps!  [Good one]   

Or Truncate the table so you do not write to the Transaction Log - I am assuming you do not need to keep track of whatever data was contained within...

"...or something else..."  Gotta love that!   

You may try running sp_who2 when this is running at those different times. It is a...

Sonia - I think you are overthinking your first question.  Look at the following: 

DECLARE @Account TABLE( Account_Number varchar(6) NOT NULL PRIMARY KEY, 

                                      Branch_Name varchar(12) NOT NULL, 

                                      Balance money)...

Thanks.  Did not realize COUNT included NULLs.  Thought all aggregates disregarded them.  That is important to keep in mind!!   

That is why I used ASCII.  It did not matter which of the previous records was used, only that the MAX( Col3) WHERE the ASCII( Col1) was less than the...

You lost me Joe.  Your psuedo-code has no equal and has a missing paren. 

"proprietary UPDATE... FROM.. syntax."?  Can you explain for me? 

Thanks

NULL does not equal NULL.  NULL is the absence of information, not a value. 

Try this: 

Instead of: (count(SaleItems.InstalledDate = null)> 0)

Try: COUNT( CASE

                    ...

Thanks.  That is actually what I was trying to get across.  Why not update the entire table rather than selected fields? 

That is a truly strange result.  You typed it into Query Analyzer and hit F5 or the green arrow to run it? 

Never seen that result from sp_who.  You are...