It's complicated in T-SQL, but not overly so. However, I agree with Sean and Ed. If you think this is overcomplicated, I think you need to work on better understanding...

Good to see some of you doing code reviews. Not a lot of response, so I suspect many aren't.

Those of you doing testing as well, we'd love to hear more,...

You have a WHERE clause that limits to 2014. You'll want to group by years to get the values by years.

However, if you want to move them into columns, you'll...

Are table1.username and table2.username columns? I'm assuming you mean that you want to check if any of the values in table1.username exist in table2.username. That's an easy check:

if exists (select...

Either of these applicable?

https://support.microsoft.com/en-us/kb/182867

http://stackoverflow.com/questions/15367066/access-database-engine-stopped-the-process-because-you-and-another-user-are-atte

Have you tried a repair? https://support.office.com/en-in/article/Compact-and-repair-a-database-6ee60f16-aed0-40ac-bf22-85fa9f4005b2

You must have some alias on the first machine.

UDP 1434 is the listener for the browser service. It lets you know things are working. The connection (by default) is on...

jonathan.crawford (4/24/2015)

---

Steve, my brother is getting hitched on the 4th of July weekend in Breckinridge. I'm not sure we're going to be able to make it, but assuming we do...

The resource file has been updated with a new version from Adam.

john.arnott (4/22/2015)

---

Steve,

Two food items to not miss: The Gordon Biersch mini-brewery's garlic fries (perfect excuse for a beer to wash them down), and the Cha-Cha Bowl from Orlando...

Heading to Pac Bell tonight to see Dodger v Giants. Kershaw v Baumgartner.

Excited. First time at the park.

sp_executesql isn't in your linked server db. It's in master.

The issue is that you really need to execute this as master.dbo.sp_executesql, but through a linked server.

You'd be better off using...

It's a bit of both....

RonKyle (4/20/2015)

---

...

I can't say that I think SSMS 2012 is better/worse than 2008/2014. Still a pig and slow, and randomly crashes on me.

At least a few more of the dialogs fit...

I'm off the VMWare for the week, so get ready for a bunch of stuff on why virtualization is the best thing ever and all of you are doing it...