Eirikur Eiriksson (4/24/2015)

---

Quick trick, in SSMS press CTRL+ALT+G to view Registered Servers, if they are grouped you can right click on the group, new query and that instance of the...

ken.trock (4/24/2015)

---

Gail Wanabee (4/24/2015)

---

I've seen code reviews required in some shops, little or none in others.

My personal execution: I almost always ask for a code review from a co-worker, even...

Yeah, that's probably the best type of solution, Jeff. Didn't think about tally tabling that, but it's a good use with dynamic SQL for a limited number of items, along...

That's it. I don't believe the UAC on any server OSes notifies you to open ports. The client versions (7, 8) seem to ask you to open the firewall.

Apologies, I...

Thanks for the update. Hadn't thought of the firewall, and I thought that it was opened by SSMS, but perhaps not. I'll have to try and see.

What OS?

I'd crosstab it more like this:

SELECT customers.name,

SUM( case when year(date) = 2014 then unitprice*qt else 0 end) AS total_2014,

SUM( case when year(date) = 2015 then unitprice*qt...

I think you might have a 2012 alias set up on your client.

https://msdn.microsoft.com/en-us/library/ms190445.aspx

Just saw this, and didn't want to leave it unanswered.

If you are on 2005, and can't use PoSh, I'd actually script this with SQLCMD and use VBScript to call SQLCMD...

Sunscreen is important. I'd also caution you to bring a light jacket always. A 90F day can turn cold quickly when the sun goes down. Much different than sea level,...

If the users have access to the tables, you can't prevent this. You could make it hard, perhaps with some trigger that looks for Access directly manipulating things by using...

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