Adaptability, I think is key to survival in this business.  But as Jeff said 'change for the better is not'.  And at my previous job I was labeled 'resisting change'...

Happy Holidays to all!  I don't think I'll see Star Wars this weekend.  Even though I have a chance to go see it for free on Friday, plans changed so...

p.s.  I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies".  It there's not a well documented ticket to support the urgency, it doesn't get...

Is anyone one else still getting directed to the wrong page of responses?  I was on the 'Active Threads' view and clicked on the link for Josana.work response on this...

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

p.s.  I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies".  It there's not a well documented ticket to support the urgency, it doesn't get done. ...

What I hate is when you get the 'Urgent' email on a request for some data.  Then you spend the rest of the day working on it.  Then the next...

Thanks for the feedback.  Like I said this was my initial thought to join them into one, but the more I thought about it I was thinking I should go...

I'll be using this data to add entries to our data warehouse tables.  After using this data to fill in our data warehouse tables most of the time it will...

Major congrats on the "term" to "perm" thing.  They should rename the "term" position to "Damocles".

As for migrating SSIS packages, I've discovered a sure fire way to...

I guess I don't understand why anyone would write software based on the knowledge of novices.  If it's important for a novice to be able to maintain...

I guess I don't understand why anyone would write software based on the knowledge of novices.  If it's important for a novice to be able to maintain something a...

The standard pattern for getting the first day of the month is:

SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)

Stick to that pattern, don't corrupt it with -1 tricks!  That just makes...

You should be able to pass any date to the code in the last statement to get the second to last date of the month based on the date used. ...

I don't...

Simple join on the ID columns, use sum and case for the amounts.   Give it a try and post your code if you are still having trouble.