I'm using a sandbox database that I own, I substituted MyDB above to make the code more clear. The database _Sandbox_Brad is selected.

This is the actual step query:

Select *...

It appears that the LoginName under which SQLAgent is currently running is "NT AUTHORITY\SYSTEM". However that was why I told it to run the job as me, since my...

First of all, you have more than one field causing duplication, in the example I found on my server all of the fields after alloc_unit_type_desc were also different, so you...

When I have queries finalized I do turn them into a view or TSQL, it's just the design process usually pretty complicated and finicky, so I use SSMS as I...

rmechaber - thanks, I'll give SSRS a try. I use Excel often as a cross-check on the results, copy the data over then use pivots to validate results. ...

R_S - using IsNull or Coalesce isn't an option, because I regularly deal with hundreds of columns, any of which can have nulls. To change my ad-hoc query to...

R_S - I have been using the Excel replace method. I just was hoping there was an alternative setting that would make that permanently unnecessary because I've done it...

I haven't really used SSRS (we just upgraded from SQL Server 2000 and didn't have it before) - is it possible to create a generic wrapper report that will take...

I'm guessing that to use automation you also have to have Excel installed on the SQL Server which in any organization with a controlled software environment may not be the...