Thank you so much - that works!

Meanwhile I was playing with my own code, and I think I got an alternate solution using nested cases:

SELECT

OpportunityID,

ActivityID,

FirstVisit,

ScheduledEnd,

CASE

WHEN CONVERT(DATE, ScheduledEnd) = FirstVisit

THEN

CASE...

Chris Chilvers (4/26/2007)

The backups store the path of each file that was backed up, by default a restore will restore these files to the same path.

The trouble comes when restoring...