It's hard to understand what you're really trying to do. You mention VLOOKUP and HLOOKUP which are Excel commands and not SQL commands and you are in a SQL...

Sorry, I posted accidentally and just finished re-editing it and now I see you have replied. See that post. TOP will have the same problems as MAX.

I have not done sequence counters with triggers, but I can tell you there is a fundamental weakness with using MAX(ISNULL(SequenceNumber, 0)) for generating sequence numbers that you then...

If the operators never get a mail, and your SQL config all appears correct, it's also possible that some spam filter on the email client or email client network is...

I don't mean to belabor the obvious, and there are a bunch of limitations that may make this non-feasible depending on how much of the infrastructure and code you control,...

Perhaps I am restating the obvious, but at a minimum, you can use set-based operations to set values for all columns that don't require a stored procedure to set them....

If you want to control the width of the data, then in the SELECT query that that sp_send_dbmail calls, cast the columns you are fetching to the desired width, (possibly...