Don't you just love it, when you hand a process over to someone else, so that you can spend more time getting the "important" things done? Just you just love...

Just chiming in here, but want to understand something. In your original post you mention you want the load "this month and last month's". So, for the current month that...

Ok, maybe I should elaborate a bit more.

With the sample data you provided, and solution I gave, you received the correct answer (good). However, when applying it...

12GB isn't really a lot for a SQL Server. Especially if you have SSAS, SSIS and SSRS all on the same instance. YOu also say you have RAM ring fenced...

Most of the stuff I work on are request from other staff members, which has to go through a web application we use. This normally works fine, as the staff...

DDL, Sample data and Expected output is really important here. I'll need all of this, showing the problem you're having to be able to trouble shoot. You're returning data from...

You can upgrade VS now if you wanted. VS 2015 with SSDT 2016 can deploy to SQL Server 2012+, you just need to ensure you select the right TargetServerVersion in...

A repair isn't a reinstall. Have you tried uninstalling and reinstalling the feature?

Nevermind, what I was working on suddenly wasn't wanted anymore just after I made the above post. Love it when that happens :D.

Again, this is untested :

The only way I can really see this, unfortunately, is by using a Cursor. This isn't quick, and thus I'd strongly recommend Changing your set up (I'm not sure that...

Also, that SP wide open for injection.

Edit: Ok, honestly, that entire SQL is a mess. You have a table [Employee] and a SP called [Employee] You can't do...