Right click on the table in the Object Explorer Pane, select Open Table.

😎

Hard to tell from the question alone. Michael Earl is right, we need to know more from the OP before we can really answer the question.

😎

Here is what I found in BOL.

G. Moving tempdb to a new location

The following example moves tempdb from its current location on the disk to another disk location. Because tempdb...

The easiest system database to move is tempdb. If memory serves me, there is actually an example in BOL on how to move tempdb. It does require a...

I had a little time here at work and started looking at your code a bit. Something I noticed was the use of 3 part naming conventions in your...

I only gave you the query, you'll need to put it into your proc.

ALTER PROCEDURE [dbo].[spTEST]

(

@LineNum VARCHAR(10) = NULL,

...

There are somethings I can do, some things I can't, and some I just don't want to do. I really don't want to work on the cars, I'd rather...

charles.frank (7/11/2008)

---

Is there a way I can reduce the duplication in this stored procedure? In each if statement, I have practically identical code except for one line in the...

mailsar (7/11/2008)

---

RBarryYoung,

I have a Question,

Is 1 better or 2 better(Join).

1.

FROM Product, ProductType

WHERE ProductType.ProductTypeID = @ProductTypeID AND

...

CTE's alone won't eliminate your cursors. You have to totally relook at the process from set based view instead of a row by row view as is done with...

You noticed,...

Could be...

What we have: current code, table DDL, sample output.

Missing: sample data for the tables (in the form of INSERT statements that can be cut, paste, and run in SSMS to...

Although the WHILE loop eliminates the CURSOR, it doesn't eliminate the RBAR. You are still doing row by row processing.

In order to really help, we need additional information. ...

Marty Benson (7/9/2008)

---

I was actually expecting this article to show me why I needed the "INNER" keyword when using "JOIN".

I always just use "JOIN" without the "INNER" and I was...