True.

And one other thing I just thought of, your clustered index is a part of the covering index even though you can't see it.

Assume that ID is the clustered index....

Statistics are enough the same between the versions that you don't really need to worry about them too much.

The only way to create a covering index in 2000 was to...

The overwhelming majority of our production systems are 2000. We're starting an initiative this year to get them upgraded to 2008 over the next two years because, in 2010, extended...

How does table 3 relate to the others?

Also, didn't this get posted before in the same form?

Abhijit More (1/21/2009)

---

I think below example will give you better performance ...

CREATE TABLE tmpProduct

(

ProductIDINT IDENTITY(1, 1) PRIMARY KEY CLUSTERED,

ProductNameVARCHAR(10)

)

CREATE TABLE tmpProductSales

(

ProductSalesIDINT IDENTITY(1, 1) PRIMARY KEY CLUSTERED,

ProductIDINT,

TotalAmtMONEY,

BalanceAmtMONEY

)

INSERTtmpProduct(ProductName)

SELECT'Pr0duct' UNION

SELECT'Pr0duct2' UNION

SELECT'Pr0duct3' UNION

SELECT'Pr0duct4'

INSERTtmpProductSales(ProductID,...

Are you trying to insert into the first temp table filling the gaps?

Because if you're simply trying to insert unique numbers, you can get the max value from the original...

And if you want to get really confused, then, without an IDENTITY setting on the column, when the table is empty, the MAX value should be NULL. I'll bet that's...

Great. Glad to hear it. And thanks for posting the success of the suggestion.

So when you say you want to "extract non-generic sql" do you mean that you have stored procedures in your database that you need to pull out or that you...

I didn't have that one on my list. I do now.

Check out the Books Online for the topic SQL Agent. Agent is a scheduling process that will let you run lots of stuff, including TSQL batches, on a scheduled basis....

One place I've been visiting for bits and pieces is this blog: http://blogs.msdn.com/sqltips/default.aspx

But by & large, for focused information, Gail has given you what I've been using.

There is also the...

mgalgey (1/20/2009)

---

Thanks Steveb,

I want to capture any custom code that is in the stored proc that is not auto generated and insert it into the new stored proc.

Eg

Old ...

Oh, and it goes before the ORDER BY clause.

Try using the HAVING clause. Look it up in Books Online for details, but it would look something like this:

SELECT...

FROM...

WHERE..

GROUP BY...

HAVING SUM(MyValue) > 0

It's sort of like a WHERE clause...