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 5 years, 9 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.

London would be interesting. The SuperBowl is such an event and exepnsive. Likely not much more cost in London than LA for attendees.

Long as they don't change the...

Well, there is no way in hell I would have thought this would have updated the table.  But Drew proved me wrong, well done sir.  Learned something new today.  Still...