darn it....it's not right...not filtering by week...

I changed it (a little)..

SELECT

E.eecCoID AS 'Rec ID',

E.EecEEID AS 'Emp ID',

eepNameFirst AS 'First Name',

eepNameLast AS 'Last Name',

EecDateOfOriginalHire AS 'Service Date',

EecDateOfTermination

FROM...

I think that's it....checking now..

Thank you so much Andy!

Okay here's everything I have so far...runs, but not correct results...not filtering by week..

can't figure out why

--With Terminations

SELECT

----DATEPART(YEAR, e.eecDateOfLastHire) as 'Year of Hire',

--EEPDATEOFBIRTH,

CmpCompanyCode as 'Company Code',

E.EecOrgLvl2 as 'Org Level',

cmpCompanyName as...

I'm close but this isn't right....

(SELECT MAX(EC.eecDateOfTermination) FROM EMPCOMP EC WHERE EC.EecEEID = E.EECEEID AND (eC.eecDateOfTermination <= (SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0)) AND (EC.eecDateOfTermination is not null OR EC.eecDateOfTermination >= (SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6)))))...

Exactly what I needed.

Thanks Jeff.

Sorry.

Is there a way to eliminate the duplicate Employees, taking only the latest prgpaydate in the CTE?

So really in my worst case senario the adding the witness doesn't help me much.

Thanks for all the help Lynn.

-->sending you good karma<--- 🙂

Lets say the power goes...

Maybe then I'm doing something incorrectly..

I have two...

Okay..

I'm stuck with using standard...

thanks guys

thanks George

Ahh...interesting stuff Craig.

Guess the bottom line is, I gotta setup 'normal' backups.

Thanks Lynn, Craig. Much appreciated.

Okay. My understanding is that they are only using NetApp to backup/snapshot those instances. Not the entire VM.

If the above is indeed the case, is there anything I can do...

Oops! Sorry my apologies to both...long day.

So, bottom line -

Using NetApp to backup is not supported by Microsoft, correct?

Only real solution is to create 'normal' SQL backps