Are you sure your runing SQL 2005?  I tested that entire script on my development copy of SQL 2005 and it runs as expected without errors. 

When I change the...

Jezemin: I hope I didn't insult you, but I just wasn't sure if you were being facetious.  I guess I really am feeling my age

Post the complete SP text and put a comment above the line where you can't seem to catch the error.  @@error needs to be captured IMMEDIATELY after the call to...

Thanks Steve.  Even though there is always room for improvement, I thought I'd take the opportunity to let you know I think the site is great!  It has been a...

Your welcome.  However I'd like to know if I just did you homework?  If I did let me know what grade I got

If...

Jezemine: Is that a serious question?  If it is I think I'm beginning to feel my age.  The reason for CAPS in any code use to be to indicate reserved...

Jeff: I agree, if I had known it was home work I would have tried to give hints rather than the solution.  I don't know why it didn't occur to...

Midan: I beg your pardon, but I don't think my syntax was incorrect, I think your question was lacking in information. My solution of adding to the trigger of the "New_TB"...

No problem Jason.  I started down that path but then thought someone has to have done something similiar and a quick search turned up the script I posted a link...

Interesting problem.  However you didn't say what the table looks like that you are inserting into, but assuming it has a single integer column the following will do what you...

You didn't really provide enough information for a complete analysis of the data/situation to be modeled but assuming you need to end up with a grid similiar to what you...