I'm looking at the details of the stored procedure now.  From what I'm seeing, all temp tables created within the stored procedure are dropped at the end.

...

This winter my computer project has been starting to scan and digitize four generations of old b+w family photos from about 25 albums that have been stored in boxes...

One of my best days was last year.  We were moving one of our systems from an in-house developed application that I was primary support for to a vendor cloud...

At my company, we have a subscription to one of xIgnite's services to get the US Treasury rate.  We have a .Net project that pulls the treasury rate and loads...

It looks like you're missing the actual SUM in the second query.  I would expect it to be something along these lines:

SELECT
title, certification, SUM(earnings) as earnings
FROM business_ledger
WHERE...

I love when past me leaves notes for how to solve a problem that present me is having.   🙂

That has proven helpful so many times, that I've picked up a...

Is anyone else having trouble getting to the second page of this thread?  All other threads are fine, just this one I can't get to the second page.

I find that I work better with a to do list, especially when I'm feeling overwhelmed with tasks.  I've tried a few different software to do lists, but never really...

I had to take one of our production systems off line this past weekend so that another group in the company could do some server maintenance. After going over...

Jeff Moden (10/30/2016)

---

aaron.reese (10/30/2016)

---

Agreed. but when you are prototyping it is very likely that you don't have the full story from the business, especially where they need to persist changes...