How about a CTE like this one?

create table #EmpDaysOff(

EmpID varchar(5)

,Code varchar(5)

,FromDate datetime

,ToDate datetime)

insert into #EmpDaysOff(EmpID, Code, FromDate,ToDate)

select 'A', 'Hol', '20121015','20121017'

union all select 'B', 'Hol', '20121015','20121017'

union all select 'C', 'Hol', '20121017','20121019';

with...

If the records in history have the same date without a timestamp there needs to be a unique way to identify the latest record. If RecID is sequential then...

Here's a tweak to the code above to get rid of the error...

still not sure how to get your 2nd requirement to concatenate the 2 dates if they're on the...

I wish I knew.. the only thing I know is that the application that uses the database is written in VB 6.0 and it allowed users to create objects in...

Regarding what happens to data from 00.00 to 00.10 depends on your backup timeframe... if u backup every 5 minutes then you'll have a t-log backup file @ 00.05 and...

The secondary DB will be 00.00 since that was the log file that was restored from the primary log backup. Secondary will always be behind primary and since the...

I've noticed sometimes that on new cluster setups the servers will lose the drive letter or even use a different one when you failover, especially with iSCSI connections. check...

If your backup script is using the native "Backup Database" then it's not... Litespeed backup scripts are different something like "Litespeed.exe -d..." something like that... it's been 6 months since...

How about using SSIS to pull the data from all the sql instances and send an excel document from it?

Maybe setup a table with all the server names and then...

Any new processes scheduled to run during the backup period? If the overall size of the DB is the same and the type of data remains the same it...