Something like this

SELECT

a.name,

b.name

FROM table1 a

inner join table 2 b

on a.name = case when b.name = 'BO' THEN 'Boston'

WHEN b.name = 'bos' THEN 'Boston'

WHEN b.name = 'NY' THEN 'New York'

ELSE 'na'

END

You can use dbcc loginfo to find active VLFs and their status.

User!UserID displays the name of the user (domain name or other credentials passed in) executing the report, assign this field to a parameter in your report.

report parameter: @userID

value: =User!UserID

With some...

Here's one solution

There is a Built-in Field named UserID (=User!UserID). This userID is the user's name that is passed through the reporting system when the report is run. This can...

If your cluster is created find your cluster name by looking in the Server Manager under Features > Failover Cluster Manager > Services and applications > [instanceName].

In the resource window...

In a cluster you'll have a cluster name, a virtual domain object. This domain object will have its own IP assigned and will connect to whichever server is hosting the...

"Play me or trade me."

I say trade him.

Sure, providing a solid definition for the term is tough. Until it is proven that runs late in the game are more important than runs early in the game, I'll...

What is up with Oakland! They are tearing it up, I'm unsure if they're really good or Texas and LAA are really bad. I know pujols was struggling but one...

Yeah, that's the problem I now have with "clutch", it is meaningless. To try and have a formula for defining a clutch score based on probabilities and leverage indices, c'mon....

Derek Jeter, "Mr. Clucth". David Ortiz, "he's a great clutch hitter".

What does "clutch" mean? Is there any evidence of this term manifesting itself in a game?

This is a term that...

If SUM(C.PeriodsAbsent) > 1000, it will break. Your cast limits values to 999.9 at the most.

What is the value of SUM(C.PeriodsAbsent)?

Jeff,

I have the very script you're looking for that does exactly what you want.

I pieced it together using a couple functions I found online and it works very well.

-It...

Dealing with smaller virtual environments where I'm not necessarily constrained by a lack of resources, I'm always inclined to keep one instance on one server. The main reason being stability...

10.50.4000