I made it clear I wasn't a fan when SSC went to the new version, but to me it is still light years better than SO.  IMHO 🙂

We are being asked to work at home thru March 27.  Then I think they want us to switch off with 50% in the office 50% work from home...

We are being asked to work at home thru March 27.  Then I think they want us to switch off with 50% in the office 50% work from home for...

That's some bad code there Mike.  I've seen some similar, but add a couple UNION statements and all with in an SSRS report.  Talk about slow code.

I've...

That's some bad code there Mike.  I've seen some similar, but add a couple UNION statements and all with in an SSRS report.  Talk about slow code.

I've also had that...

Another venting.. first thing though, I don't want to get into the whole argument on of using EOM vs BOM.

Where I work currently they use EOM.  Which is fine with...

Not a 100% on this, but set the SQL for each to not check for a specific employee.  Set the page breaks to be on the Employee.

Thanks Brian, this works.  And for what I need this for speed isn't an issue.  Just saving me time from cutting and pasting or typing.

Sorry, I was in a hurry to get this out before a meeting.  I don't want the dynamic SQL statement to be stored or used outside of me trying to...

Speaking of a comedy of errors.  This past weekend they moved our servers to a new location.  After the move they released any jobs that were on HOLD.  Now I...

I heard a song on the radio the other day that was a parody of Aerosmith's 'Sweet Emotions' called 'Sweet Emoji's'.  Not sure the comedians name, but it got a...

I like the simplicity of finding the February 29 dates, then subtracting that DesNorton posted.  But it didn't calculate correctly when I used the start date of 01/01/2019 end date...

Thanks for the feedback and info Jonathan, I'll take a look at it.

Found lots of holes in the prior SQL I posted, here is my revised SQL:

DECLARE...

Of course, if I would read through the comments(at the link I posted), Jeff Moden would have a simpler way to determine a leap year.

SELECT 
CAST(DATEDIFF(d, @Eff_Date,...

• This reply was modified 6 years, 5 months ago by below86.

Maybe I just needed to post something to get the brain going.

Here is what I came up with.  I borrowed some code I found at https://www.mssqltips.com/sqlservertip/1527/sql-server-function-to-determine-a-leap-year/

DECLARE @Eff_DateDATE;
DECLARE...