Any solution to this ..even I am facing the same issue. Any pointer would be very helpful

This helps...Thanks a Lot shield 🙂

I mean if there is any discontinuity for an employee in his work, (For e.x EmpID=3 EndDate is jan31st and started his work on march 1st again ), so i...

@Kavitha: Thanks for the reply, Can't we make it a generic querry rather than filtering the records by hardcoding the empid = 3

@Ashish: I am sorry i didn't get your...

We are not creating a new empid if the employee already existed.

The Gap was due to the employee was out of the company for sometime and he joined the company again after some time.

Hope this make sense.

Thanks in Advance.

Hope this helps:

SELECT SUBSTRING('123n_abcn_123n',CHARINDEX('_','123n_abcn_123n')+1, CHARINDEX('_','123n_abcn_123n',CHARINDEX('_','123n_abcn_123n')+1)-CHARINDEX('_','123n_abcn_123n')-1)

There is gap for empid= 3 so i need two records for empid=3 in the result, hope this make sense.

ex:

select * from duration

where EmpId = 3

ouptput:

EmpIdStartDateEndDate

32010-01-01 00:00:00.0002010-01-31 00:00:00.000

32010-03-01 00:00:00.000NULL

Your result...

@free_mascot

Thanks for the reply...The size of log file should be 20-25% of the whole Datafile or the striped ndf's.

sry was very urgent so had to cross post...

thanks for the correction Mr.Steve..

if you have your database backup file striped or the tranlog backup striped then you can restore only that required 20 gb of the file to the drive and...

usually for every hour you take your tranlog backups...if your data is corrupted in the mid of the hour like 1:30,something like that ..for that remaining half hour you take...

lite speed 100gb backup to 10 gb in 10 min –cost approx $4000.you also have table restores. litespeed rocks...

if your remote server is an oracle server then use the OLE DB provider for the ORACLE provided by the Microsoft.not the native SQL server provider. make sure that...