When you refer to a new fature of SQL2014 you might refer to the new server level permission "CONNECT ANY DATABASE" in combination with "VIEW SERVER STATE" and "DENY SELECT...

You'll need to perform a second join to the members table:

select t.*, m1.lastname, m1.firstname, m2.lastname, m2.firstname

from tickets t

LEFT OUTER JOIN members m1 ON t.assigned_to = m1.member_id

LEFT OUTER JOIN...

TomThomson (8/13/2014)

---

I wish I could give you some of ours. I'm beginning to dislike English summers nearly as much as I disliked English winters in the bad old days...

Evil Kraig F (8/12/2014)

---

More than a few reasons why the top of the hills were considered the best real estate way back when. I'm glad to hear everyone so...

With 70$/hr you're talking about roughly 140k/yr if you're a full time employee...

If that's your current situation, then the only alternative would be consulting.

Yes, you could make more per hour...

If that's the case, why isn't Oracle listed as a required qualification?

Or do you mean they're asking for a SQL Server expert...

That's weird:

and

QUALIFICATIONS: Highly experienced in Database design and Administration performing the following:

• Expert knowledge...

Not enough information.

What do you mean by "tallied"?

Any sample data (table def, sample data and expected result) available to demonstrate what you're looking for?

Based on your -rather vague- description I...

What are you trying to accomplish here?

It looks like you return the running total balance per month an fiscal year.

Why would you worry about this FY having less than 12...

Does the user "james" has the permission to connect to database "data"?

Or how do you handle the connection between the two databases (users and data)?

Yes, you can use a second image: one that is officially...

You can't create views across database using the syntax you're thinking of.

Instead you could create a view on each database and use that in your view:

create view view1 as

use

select...

To expand on Lynns idea:

It might be an additional "feature" to set a minimum number of forum posts before being allowed to flag a thread.

While I do trust each of...

Sometimes it's essential to know what the application will do with the data.

Let's just assume a scenario where they would just filter out 10% of the data and throw the...

In your very first post you mentioned the result is used by people looking at it.

It's rather unusual to present 280k rows to a user...

So I need to ask: what...