I've hardly used STR(), so I didn't know about all of these pitfalls. Thanks for the Spackle!

Yes.

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.)...

ASDL (12/14/2010)

---

My question still holds how do I write this SP so that I do not have to change it in future if columns are added or deleted from the...

Stefan Krzywicki (12/14/2010)

---

Wow. I was having problems with an older query taking too long, so I made what I thought was a little switch to begin making time improvements. I...

Paul White NZ (12/13/2010)

---

Typically, these are achieved by:

1. Truncating the staging table at the start of the SSIS package (an Execute SQL task)

2. Dropping any nonclustered indexes on...

Paul White NZ (12/13/2010)

---

I'm not dismissing the idea at...

Now to handle what HappyCat mentioned with your code:

DECLARE @Desc VARCHAR(5000)

BEGIN TRY

-- Generate a divide-by-zero error.

SELECT 1/0;

END TRY

BEGIN CATCH

...

Did you ever do anything with that missing index on those processes in the c.u.r.s.o.r.? (Or making the CI on BatchGroup?)

I agree 100% with shooting down Method 3.

Your DBA is a pretty smart guy for being able to do #2. Normally, I would be inclined to agree with him. However,...

How about this?

SELECT t1.NumericalRanking,

AlphaRanking

FROM (SELECT NumericalRanking = really complicated code FROM MyTables) t1

JOIN rankings...

That depends - do they do it in person, or...

Phil,

So, something like this?

-- store off what you're doing so you can mark them as processed

DECLARE @TableNew TABLE (RowID INT IDENTITY, Col2 = PK of TABLE);

INSERT INTO @TableNew SELECT PK...

Tom.Thomson (12/12/2010)

---

Yes, it changes now...

I knew there was a simpler way, but I just couldn't figure it out. Thanks Jeff!

Done, sorry about that!