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...

Reality - What a Concept (-- Robin Williams)

😎

Also, you can't use a variable in a select statement for a tablename, unless the variable itself is a table variable (confused?).

What you are trying to do would require the...

Betty Sun (7/9/2008)

---

Hi all,

I have a stored procedure. But it seems that you cannot use variable for a table. variables are only can be used in condition expression? What about...

Okay. Good to know. And yes, I still want to run the UPDATEUSAGE. It just really bothered me that I couldn't remember it.

Thanks!

😎