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

I'm not aware of a good, all encompassing SQL Server 2005 tutorial. I'm with Jack. You'll need to hit JumpstartTV, Simple-Talk, and of course, here at SSC, to get the...

Jack Corbett (1/19/2009)

---

Grant Fritchey (1/19/2009)

---

What? Did the copy editors fall down on the job again. Steve, fire that mangy lot and get someone decent in...

What? Did the copy editors fall down on the job again. Steve, fire that mangy lot and get someone decent in here to protect us...