This sounds like something that should be done via code or SQL as the data is pulled out of the column.  You can set an integer value of 1 to...

The exact thing the developer is trying to avoid doing here is the way to do it.  Why would the developer want to avoid creating a variable to hold this...

Well, rewriting your work Set based is a bit of a chore without having your core tables, views, and data so please take any work that...

Yes, I understand this part as the code is coded this way, but I thought the purpose of this SP was to get the next level if it exists.  Wouldn't you...

Yes, that makes perfect sense to me.  Amazingly, this is what I gathered from reading your code.  But the problem is, your 2^nd SP does not...

Yes, that makes perfect sense to me.  Amazingly, this is what I gathered from reading your code.  But the problem is, your 2^nd SP does not...

I am a bit confused by the logic in your sp_getnextlevel_single procedure as it appears to always return the same level that is passed into...

Also, you are using SELECT INTO to create temporary tables to use in your procedure.  SELECT INTO copies the table structure in terms of columns, but indexes are not copied...

Your best bet here will be to post your table DDL and your code.  SQL Server works best by operating on Sets of data, not row-by-row (look up RBAR...a Modenism...

Yep, you're correct.  Thanks for the catch

I would recommend using the trigger to insert notification rows into another table.  Then set up a job to read that table and send the e-mails.  The reason for this...

There are a number of methods you could use to do this including, but necessarily limited to, the following example.  All three of these methods are well documented in BOL. ...

A task that shows up as blocking itself is usually a result of the task waiting on I/O.  Check the wait type the next time you see this occur and...

I'm not sure if I'm following you.  Do what a million times?  The solution I provided will obviously need re-written to use your real table/column names, but it will...

jesus,

In what way is your problem similar?  You would probably have better results in terms of feedback on your problem if you start a new thread.  Also include any...