If you're a newbie, I'd actually recommend Datawarehousing for Dummies as a first book. You'll find no actual coding, etc., but it does make many of the concepts easy to...

I wouldn't rule out a bcp based solution with format files for each client. You could then call it, automatically switching out format files based on which client you're processing....

Do I have a blank check to go with that blank slate?

I'll second what Jeff mentioned, but it would also help greatly if we knew what you were going to...

Since you're using Latin1, case insensitive, and accent insensitive, is this what you're looking for? It's not MS SQL Server, but I didn't find anything obviously wrong with it....

If I understand you correctly, and you're trying to find records in PK that don't have a corresponding record in FK, based on the FK value in the PK table...

I'm not positive if it will monitor jobs that just didn't run, versus jobs that failed, but you might want to try SQL Sentry (there is a free trial...

The safe method (i.e. not messing with system tables) is to try and get a network admin to log into the box directly and open up Report Manager, then giving you...

The OBJECTPROPERTY function works only in the current database, so it's crossing IDs. You can either avoid using that, or alternatively, you could build a 'USE ' + @dbname +...

Your job is running in the security context of your SQL Server Agent. Make sure that user has permission.

No problem at all. We actually emulate a role based security model that way (it's truly role based, but the roles are handled by an internal app, and are not...

Have you tried granting EXEC privileges on the appropriate stored procs to the stored credentials user?

The Order by should be applied after the WHERE clause in that wrapper query, which was the goal. Is it possible for you to post the exact queries that you...

That's why we turned it into a derived table. The column alias will work like a charm in the WHERE clause using that method.

My query that I wanted you to try should do that.

I always prefer stored procedures, especially for more complex calculations. This isn't even specific to RS, as many of us had the same mentality in the old Crystal Reports days....