I think it just boils down to lack of traditional title. "The plumber" is a title that goes back to ancient Rome. "The doctor" has similarly ancient origins....

The proper way to do this is create a script that drops all the FKs, modifies all the columns, then re-creates all the FKs.

In Query Analyzer, find all the FKs,...

You're welcome.

By the way, "SSCrazy" is a title, because of my number of posts. My name is Gus, and my screen name is "GSquared". It shows up above...

You can't have a column in a view that isn't in a table, unless the column is just a computed column of some sort.

Views don't hold data that way.

You can...

T-SQL doesn't do that. Not what it's for.

This:

select EMPNO, sum(HRS_WRKD), PAYCODE_NAME

from employee

Is probably actually:

select EMPNO, sum(HRS_WRKD), PAYCODE_NAME

from employee

group by EMPNO, PAYCODE_NAME

The way to get the second query is get rid of both copies of "PAYCODE_NAME"; both the...

The Where clause is essentially changing them back from Outer to Inner, because if ocv3.valuetypeid = 13 does not exist, the Where clause will eliminate the whole row.

Try this, see...

It depends on what you are trying to do in the function.

The purpose of the model database is to be a template for any new databases you create. I'd take a close look at what's in it that's taking up...

I get that you're opening 8 connections. I think I'm reading that they are to 8 different servers. Is that correct?

You can add calculated columns to views.

create view dbo.CalcCol

as

select Name,

left(Name, 1) as FirstInitial

FirstInitial is a calculated column from Name. Is that the kind of thing you're talking about?

I'd break out the sub-queries and test them as stand-alones.

You can't create a view with a stored procedure in it.

You can create a proc that will do what you want, but not a view.

Look up "parameter sniffing" online. This site and others will have a lot of data on what is probably happening.

If I'm reading this correctly, there's an option in Management Studio to open the object browser when you open Management Studio. Does that do what you need?