ha! that's what i get for not looking at a complete listing of fields available for sys.columns...must have skimmed right over it.

it is a Monday...:hehe:

So I said I was a novice, right? lol...it appears my problem was a bit of user error. I inherited this package from someone no longer with the...

Thanks for the replies. USE DATABASE is not a part of my SQl command...it's a very simple SELECT that has a GROUP BY. Would USE DATABASE be something...

Hi there, I know this thread is a little aged, but I am having the same issue in that I have a SQL Agent job that has five steps, each...

Okay, I'm an idiot...

Was trying to get the COALESCE suggestion to work and just when I was about to pull out my hair, I realized that I had used a...

Here are the variables and how the email is set to deploy:

DECLARE @subjectHTML NVARCHAR(150);

DECLARE @MissingLatestTableHTML NVARCHAR(MAX) ;

DECLARE @MissingSeriesTableHTML NVARCHAR(MAX);

DECLARE @MissingFinInfo NVARCHAR(MAX);

DECLARE @Notes NVARCHAR(MAX);

DECLARE @infoHTML NVARCHAR(MAX) ;

DECLARE @infoSection1 ...