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).

We've been talking at cross purposes, then.  When you said "This is exactly what I am trying to achieve", I took that as a reply to my question "What...

But why is that a problem?  You can have your front end display the measurements in any unit you like, so why does it matter what units they're stored in?...

I can't help you with your VB code, I'm afraid - I don't know enough about it.  If you use an Extended Events session or Profiler trace to capture the...

I still don't understand.  What are you trying to do - update the table to turn mm into inches?  I would advise you to store data in consistent units -...