--The problem with your code Luiz is that it is calculating the two periods together, but the date_block (20120406) is between the second period, so I need a way of...

Mr celko, "They are attributes of the same Vehicle, so why are they split ac cross two rows? This sounds like an example of the design flaw known as attribute...

Hi Luiz, I just posted the ddl as a guide, the values may not be 100%, should of fine tuned them before posting,have no access at this exact time.Basically its...

Cheers, thanks for the advice, have it calculating now. Everyday is a learning day.

my bad, just seen that there and changed immediatly. followed the suggestions to no avail, ive tried

-AND NOT EXISTS (select * from vehicle where Sales_Date >DATEADD(MONTH,-1,@DATE))

--AND Sales_Date...

Cheers pal, worked a wonder.

got it sorted.

sorry there is no second one ,it returns no rows

primary_idprimary_databasebackup_directorybackup_sharebackup_retention_periodbackup_compressionbackup_job_idmonitor_servermonitor_server_security_modebackup_thresholdthreshold_alertthreshold_alert_enabledlast_backup_filelast_backup_datelast_backup_date_utchistory_retention_period

C2BEA283-0F09-49C6-9B2A-1CEE4C626182mydatabase\\rentway1\BACKUP_RENTWAY\\rentway1\BACKUP_RENTWAY4320235497C9B-6E5D-4A1F-A0C2-3FB166FF7FD5NULLNULL60144201\\rentway1\BACKUP_RENTWAY\mydatabase_20120705133000.trn2012-07-05 14:30:05.3472012-07-05 13:30:05.3435760

cheers

Hi Brandie, this is the entire command from the step within the actual scheduled LSRestore job on the secondary server. "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe" -Restore 6C118D90-1559-4597-A8B4-BC1076ADA50E -server DUBMRS01

thanks alot

I looked at the steps in the restore job and it runs the command "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe" -Restore 6C118D90-1559-4597-A8B4-BC1076ADA50E -server DUBMRS01

This is not the location I set-up as a...