Have you looked in the SQL Server errorlog of the offending server?  Have you tried going to SSMS and running the query directly that fails directly against the server?  Are...

Without any table DDL and sample data from you, we're just guessing.  But, assuming you have exactly one row for each 15 minute period, all you need to do is...

Does each table have a primary key or unique constraint that's on a column (or set of columns) with similar data types?  If so, you can do something like this:

Could it be as simple as this?

SELECT * FROM MyTable
WHERE time_stamp IS NOT NULL

John

The end of Chris's solution appears to have got gobbled up by the hungry forum software.  It looks as if he was going to use GROUP BY.  Here's an alternative,...

In your results, PCCP isn't first in the second group, so I'm not sure quite what your requirement is.  In that first row, you show the days to the PCCP, despite...

Spot on, yes... or another expression that evaluates to the connection strings, just in case the server names are already set by variables!

John

Why not have a table in a database on a central server that the applications all connect to in order to get the connection strings for their respective databases?  That...

OK, please post some expected results that I can see, and I'm on it.

John

I can't see your expected results, but here's a guess.  You've posted in a SQL Server 2008 forum, so I assume that's what you're using.  There's a better method if...

The log backup can run at the same time as full - that's fine.  I would stagger the schedules if I were you, so that if the full backup starts...

Do a SUM grouped by ContractNumber and LEFT(LineType, 1), then PIVOT to get it all in one row (or, better still, have your presentation layer do the pivoting for you).