1. You do do not want a conditional join as it will kill the query plan.

You could look into creating a VIEW of the first query and then joining the...

If you need to send an image to HTML, XML etc you have to use some sort of string encoding. Here is an example of Base64:

http://blog.falafel.com/t-sql-easy-base64-encoding-and-decoding/

Just found this link:

http://db-pub.com/forum-80545268/sql-server-replication-from-sql-server-2008-to-sql-server-2014.html

My experience is that setting the compatabilty level usually works.

If you are not updating the 2008R2 DBs from 2014 you may also want to look at transactional replication as linked...

All those outer joins in sub-queries are enough to confuse anyone.

Try something like:

SELECT C.ReportName, E.ShortName AS Consultant

FROM Clients C

LEFT JOIN Consultants E

ON C.ConsultantRef = E.ConsultantRef

WHERE NOT EXISTS

(

SELECT 1

FROM Policies P

WHERE...

It sounds as though the SAN backup knows nothing about SQL Server so will not be able to backup a database in a consistant state.

I suspect you will probably need...

I suspect your SAN backup is only taking incremental changes.

1. The backups might work especially if you can see a device_type of 7 in msdb.dbo.backupmediafamily.

2. How often are the SAN...

It might also be worth checking the dbo.backup... and dbo.restore... tables in MSDB.

Glad your problem is sorted.

As Joe mentioned, general lookup tables are a bad, if seemingly common, idea although I have never been unfortunate enough to come across a recursive general...

Your test data should be consumable. (ie CREATE TABLE... INSERT ...)

I suspect your specific problem can be resolved by checking the parent is a folder:

FROM

dbCodeLookup AS dcl

INNER JOIN Folders AS...

or

-- *** Test Data in Consumable Format ***

-- Please provide this in future

CREATE TABLE #t

(

LocationId varchar(20) NOT NULL

,MaterialId varchar(20) NOT NULL

,Duration int NOT NULL

);

INSERT INTO #t

VALUES ('PlayM', 'Clip1', 626)

,('PlayB', 'Clip1',...

Umm.... I would not try to do all this yourself.

1. A restore plan is more important than a backup plan. (Backups are no good if they turn out to be...

With dynamic sql enter two single quotes for each single quote in the string

DECLARE @temp varchar(255) = 'backup database asdf to disk = ''H:\Backup\SQLTEST02\asdf.bak''';

SELECT @temp;

With the BACKUP command a variable...

I am glad you have a working solution however your test data is useless as it does not function as a test harness:

1. At a very basic level, it does...

To get a good answer you should really take the time to post test data in a comsumable format (CREATE TABLE, INSERT) and the expected results.

Your code looks far too...