This from a woman's perspective.....

1) Most women opt for a backseat position careerwise to be able to combine home & hearth with job and not lose their sanity - this...

and another depending on a different requirement...

use pubs
go

select au_fname + ' ' + au_lname as authorName, title
from dbo.authors a
inner join (select top 3 au_id, title_id from dbo.titleauthor)ta on a.au_id...

Finally an editorial that addresses my pet peeve - language!!!

I read Joel's articles more for his writing style than content though the latter is equally above par. Back when I...

"No one ever proposed something like that" essentially seems to be the only argument I too can think of - certainly discussion boards seem to abound on similar requirements (haven't...

Since temporary solutions are under discussion, I'd like to hear the arguments against "commit tran" - It does (as Rob said) - "seem to work" !!!

I'm glad I get to say "quadruple ditto" on Firefox since it gets tougher as the numbers go higher - - my system...

Rob - a couple of things - I was going to tell you to take the "exec proc" out of the trigger and make it a separate command when I...

Rob - a million apologies - I was so focusing on the fact that the trigger does not ever get fired if the insert fails that I didn't pay attention...

And that's why I said that the trigger is fired only after the insert is successful - at the point that it executes you already have a row inserted in...

okay Jeff - use your infinite reserves of patience and explain to me where Rob says that the row needs to be "rolled back"...I've read this post several times over...

Rob - the "commit transaction" is not required - the trigger gets fired only after the row is already inserted into the table....& since "they want to commit....regardless of whether...

Bill - thanks for getting SSC to banish the peel to an unobtrusive corner - personally, this site is so much a part of my life that I'd put up...

Not at all Remi - was just "passing by" on my way to the "retired people book club meeting"..

But since YOU seem to...

Absolutely - along with some sample data as well...

but to simply select the top 1 row from a table (if that's what the query is actually about) then the syntax...

This may be the logic Lee's looking for...

SELECT MAX(VerNumMat) AS Revision, 'I' AS SpecSta, a.MatNum 
FROM Product a
JOIN(SELECT DISTINCT MatNum FROM Product WHERE SpecSta = 'I')b
ON a.MatNum = b.MatNum
WHEREa.SpecSta...