Considering this is going to be a one-time conversion once we add the column to the table, I don't really see the need for a view.  The data itself can...

I just wanted to say how much I appreciate the solution to this.  I was asked once why you'd ever want to join a table to itself, and this is...

It looks like Daryl is actually putting his data in the table in a different order than you did, David.  His value is coming first with the row and column...

To call a stored procedure from another, you just use the EXEC command (assuming both stored procedures are in the same database):

       EXEC sprocB @IntegerValueVariableNameInSprocB = @IntegerValueVariableNameInSprocA

Heart attack?

I just realized you're probably going to want to create variables instead because I don't think you can reference computed columns in other computed columns.  In that case, it will...

Pam is right here, but I'll take a stab at this.

I'm guessing you are doing this in a SELECT statement in SQL and these are the items you are selecting? ...

Glad I could help you out! 

This is untested, but try this:

EXEC ('CREATE DATABASE [DCMSolution]  ON (NAME = N''DCMSolution_Data'', FILENAME = ' + @DefaultLocation2 + ', SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME =...

Good point, David.  My eyes went straight to the IF and caught the first problem I saw, and I didn't really look around it.

IF statements in SQL typically look like this

IF (some condition)

     Begin

         (some code)

     End

No THEN. 

Tab,

You can get "tickets" in flying?  I know it's an expensive hobby, but I hadn't heard of that.  I don't know too much about it, though.  At least not yet. ...

Tab,

That's definitely a perk that I would go for.  Getting my pilot's license is another one of my long-term goals.  My brother got his a long time ago, and I...

I wish I had as much vacation time as some of you!  I won't get 5 weeks until I've put in 20 years with my company.  I definitely agree with...

I'm honestly not sure it would be any faster because I'm still learning on SQL optimization, but you could try eliminating the join as follows:

 Select * From Master

 WHERE MasterID IN...